Get instant live Excel expert help with COLUMNS Function

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)

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.

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.

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?

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)

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.

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))

How do I convert Zero's to No and a number in to Yes excluding the first column labeled store #. Thank you.

Hi team. would like to figure out how to cross reference information from a column to a row.

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.