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!”
Here are some problems that our users have asked and received explanations on
Hi there, I'm looking to make Excel count a number of rows based on consecutive duplicates in one column (G), and as a result transpose data in another column (H) to a single row (independent columns) whenever the consecutive duplicates end.
Solved by I. J. in 11 mins
In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A.
need help finding the right formula
Solved by D. C. in 21 mins
Help with a complex formula where I need to count multiple data. For example an age group and if there are tall or short.
Solved by A. S. in 25 mins
Hi
I've Col D ( Tech/Non-Tech) & Col J ( contains month name ).
Now I want to see the total count of Technical or Non-Technical against the particular month.
Can you pls assist with that?
Solved by V. F. in 24 mins
I got two different tables.
Table 1 column A lists around 12000 unique Data IDs (number).
Table 2 lists in column A the Data ID and in column B a value (number).
I want to count the amount of unique values in column B of sheet 2, which all have the same value in column A of sheet 2.
In the end Table 1 in column B shall show me the amount of different values.
Solved by F. J. in 26 mins
Within the sub-total function is it possible to count only unique cells within that sub-total level. For example rows contain both and order number and a line number. I want to count the number of order numbers and the number of lines (which will be different as some order numbers will have ore than one line).
Solved by S. J. in 28 mins
I am trying to find a formula to count the number of times a month and year occurs
Solved by G. H. in 19 mins
I am trying to count the number of respondents in my data set that are of a certain age and have responded "yes". How do I count the number of "yes" responses that also correspond with another column?
Solved by V. E. in 16 mins
I am trying to count orders for customers before a date where they moderated their experience and any that cam thereafter.
Solved by B. J. in 26 mins
I am trying to count orders for customers before a date where they moderated their experience and any that came thereafter. For example if a customer placed 7 orders in total but moderated on the 4 visit, I'm wanting to see 3 for the before and 3 for the orders post moderation. I need to exclude the moderated order
Solved by I. A. in 25 mins