Get instant live Excel expert help with COUNT Function

o construct a count data and 2) a frequency cross tabulation., you may break salaries in groups of $10,000 and age in segments of 10 years.

I used the excel frequency count to count column. No problem so far. However if I were to change A2 from 13 to 93, I would expect to count in d2 to go from 15 to 14 and the count in d4 to go from 2 to 3. But it doesn't. Is this a bug or is the use of frequency completely static -- i.e. one you set it up you're stuck with the initial data? If so frequency is a pretty dumb feature. By the way, I'm using excel 2000, as I've found the newer versions extremely slow.

I've taken the personal information out of the document and just replaced with letters. But I need to be able to count the number of duplicate "user_id" rows, delete the duplicates, and add a column that totals the number of each "user_id." My document has over 10,000 rows with over 5,000 user_id's. Is this possible to do?

Please help! I've efforted, fruitlessly, in an approach to count months between fiscal years for example (OCT-SEP): months SEP-JAN are displayed in cell I27; and for (JUL-JUN), all months are counted properly. I'm not certain whether the formula assembly is applicable. The goal is to count, properly, months in fiscal years: OCT-SEP, APR-MAR, FEB-JAN, and any other FY

I have a data series in column of dates and counts. Not all dates have a count. I want to populate/fill in the series with the dates without a count so i can easily aggregate the data by week/month, etc. How can I do this?

Hi I have attached a pivot table I created to get counts for a set of data. I am unable to figure out how to get the count of gender to categorize by male, female and unknown. It is only giving me the overall value for each of the rows and columns selected.

I have a formula that needs to omit blank cells as it continues the count

I need a count of how many items have a specific word in 2 different columns.

Trying to count the number of lower scores in row b vs row d after matching the dates in row a and c.

I hope you can help. I'm trying to create a formula (in cell C9) of my spreadsheet shown above whereby I can search all countries in the header row (C1:I1) and then add the total number of times that 'Pass' is entered in the cells beneath. The result should equal 6 for the UK. The formula I have used (as shown on the spreadsheet) only seems to count the first columns of cells which has UK in the header.