Get instant live Excel expert help with COUNT 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

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.
Solved by E. S. in 21 mins
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.
Solved by T. L. in 14 mins
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?
Solved by C. F. in 15 mins
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
Solved by S. U. in 17 mins
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?
Solved by F. W. in 26 mins
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.
Solved by C. L. in 21 mins
I have a formula that needs to omit blank cells as it continues the count
Solved by Z. H. in 13 mins
I need a count of how many items have a specific word in 2 different columns.
Solved by C. W. in 21 mins
Trying to count the number of lower scores in row b vs row d after matching the dates in row a and c.
Solved by Z. S. in 17 mins
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.
Solved by O. F. in 25 mins