COUNT SEPARATE PERIODS IN COLUMN

  • Thread starter Thread starter Paul Bird
  • Start date Start date
P

Paul Bird

Hi - I am using a COUNTIF formula to count all S (Sick) entries in a column.
What I also need to be able to do is count the number of separate periods of
sickness.
E.g. entries in the column:

S
S
S
D
D
-
D
S
S

would equate to 5 days sickness with 2 separate periods of sickness.

How do I count the latter with a formula?

All help/ suggestions gratefully received.

Thanks in advance.
 
Back
Top