Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding digits in a column based on data in a separate column | Excel Discussion (Misc queries) | |||
How to count the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
Stacked Columns (two separate companies, 3 time periods) | Excel Discussion (Misc queries) | |||
Calculating return for multiple separate time periods | Excel Worksheet Functions | |||
Automating averaging a column over time periods. | Excel Discussion (Misc queries) |