COUNT SEPARATE PERIODS IN COLUMN
 

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.

COUNT SEPARATE PERIODS IN COLUMN
 

=SUMPRODUCT((A1:A10="S")*(A1:A10<A2:A11))

Regards,
Tom Ogilvy



Paul Bird wrote in message
...
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.