Get instant live Excel expert help with COLUMNS Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Prepare an Excel® spreadsheet containing the following: Column 1 - selected state counties Column 2 - 2010 population Columns 3 and beyond - values of selected variables Calculate the state's mean and standard deviation for your selected variables. Construct a frequency table and histogram for your selected variables. Calculate the mode and median for your selected variables. Prepare a Word document in which you explain normality of the distribution and assess the importance. See Assessing Normality, Section 6.6 in Elementary Statistics for more information on normality of distribution (histogram, looking for outliers) and how to assess its importance. Click the Assignment Files tab to submit the following: Excel® spreadsheet with calculations and graphics Word document (2-3 pages) with results in table, graphs, and explanation (90 words)
Solved by M. E. in 14 mins
how to i right a function that will count the number of rows in each column with a specific identifier in another? in the sheet uploaded i was to count the number of rows (or cells filled) in each column from "list view" that have the same value in column a. I know i can just do (counta(value_range) but I don't want to go through and manually type that in for each identifier.
Solved by I. J. in 19 mins
I have created a calendar to track expenses and i want to sum all values labeled Fuel. The calendar is monthly with 4 rows for each week. Fuel can show up on any day so the columns will vary but will always be in column 3,5,7,9,11,13,15.
Solved by A. H. in 20 mins
I want to use a vlookup formula to extract all the data on a line into a spreadsheet, but the data I'm extracting from does not have the data in column A on the same line each day?
Solved by I. J. in 29 mins
I've put a formula into a column of cells. It's a simple product formula, but everytime I put the value into the cell, it simply erases the formula, rather than let it do its magic. (It's the Automotive column, L)
Solved by B. W. in 22 mins
Stuck on some conditional formatting. I need column C to turn red only if column B is <50 or >90 AND column C is <.2 I'm not all that good with if, and, then statements.
Solved by D. H. in 13 mins
I am trying to use the following formula to sum a column of six items if any item is nonzero but show nothing if they are all zero. If the first, second or sixth item is nonzero, it works. But if the those three are zero, the sum ignores the third, fourth, and fifth items. Here is the formula: =IF(N(F56)*N($J$2)+N(F57)*N($J$3)+N(F58)*N($J$4)+N(F59)*($J$5)+N(F60)*N($J$6)+N(F61)*N($J$7)=0,"",SUM(F56:F61))
Solved by C. Q. in 12 mins
How do I convert Zero's to No and a number in to Yes excluding the first column labeled store #. Thank you.
Solved by K. A. in 22 mins
Hi team. would like to figure out how to cross reference information from a column to a row.
Solved by F. H. in 15 mins
I need to display the dates separated by a comma on a single cell for an employee who has taken leaves in the last 177 days from the sheet where I have our 249 employees data, date wise.... dates are on column of the sheet - "A", "B", "C", "D"... and so on....... and employees names on the rows - "1" , "2" , "3", "4" and so on.... For example: For Employee 1, I would want a display of all the dates on which he was absent - "In a single cell", dates can be separated by a comma or any other separator.
Solved by M. U. in 26 mins