StrangeFascination
New Member
- Joined
- Mar 4, 2009
- Messages
- 6
Hi everyone,
I am creating a spreadsheet which tracks sickness levels of staff. The spreadsheet is laid out with each agent representing a row, and the dates running across the top. When an agent is sick, a 1 is placed in the corresponding cell for that day.
What I need is a way to count the number of occurences as well as days. For example, if an agent has four days off in a row, this would be represented as a contiguous block of 4 cells, each containing a 1. If later in the year they have another 3 days off in a row, similarly this would be another contiguous block of 3 cells, each containing a 1. This would represent 7 days sick, but only 2 occurences. I'd like a formula which enables me to count the number of these occurences across the year.
Many Thanks in advance.
I am creating a spreadsheet which tracks sickness levels of staff. The spreadsheet is laid out with each agent representing a row, and the dates running across the top. When an agent is sick, a 1 is placed in the corresponding cell for that day.
What I need is a way to count the number of occurences as well as days. For example, if an agent has four days off in a row, this would be represented as a contiguous block of 4 cells, each containing a 1. If later in the year they have another 3 days off in a row, similarly this would be another contiguous block of 3 cells, each containing a 1. This would represent 7 days sick, but only 2 occurences. I'd like a formula which enables me to count the number of these occurences across the year.
Many Thanks in advance.