# Get instant live expert help on I need help with excel count occurrences

“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 Z. D. in 25 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 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
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
Macro inserts new template worksheet tap between First and Last tab. Inserted worksheet is renamed as a Job Number. Job number not known until after insert. Need help with a formula that can count the occurrences of all sheets between first:last, without yet knowing the inserted sheet name(s).
Solved by K. E. in 14 mins