Get instant live expert help on count occurrences in excel

“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

I have a problem regarding to Learn How to Count Occurrences in an Entire Workbook
Solved by G. S. in 14 mins
I have a sheet with the hours that people took sick throughout the year but I want a formula for counting the amount of occurrences of sick. I can count the hours sick and the total days but cant count the occurrences. How can I count the a period of sick over a number of columns as 1 occurrence please?
Solved by I. Y. in 21 mins
Trying to figure out how to get a count of occurrences where an array under a certain condition is greater than 1.
Solved by X. D. in 25 mins
I have a calendar with 4 cells (2x2) per day. I need to count duplicate occurrences of the value "S*" on consecutive days as 1 occurrence, and non-consecutive occurrence as 1 per occurrence.
Solved by V. S. in 19 mins
Hello, I need help with COUNTIF + IF function in Column C to show "First" for first occurrences of values from Column B and show "Rework" for the next occurrences. Thank you.
Solved by S. F. in 22 mins