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