# 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