occurances

[dunnes]

Hi,
i am trying to create a spreadsheet that calculates sickness days in the past year. These are simply marked by a number 1 in a cell.
The difficult bit is trying to work out how to calulate the amount of occurances of sickness. ie if i had Mon Tue and Wed off this is one occurance, if i have mon and fri off in the same week this is 2 occurances.. Is this possible?

Cheers
Mike

 

[rowett]

Not a terribly elegant solution but it works:

Assuming you have your sick days in Column A starting in A1 create the following forumula in B1:

=IF(AND(A1=1,A2=0),1,0)

Drag that formula down column B and then SUM column B to get the number of occurences.

Chris

 

[dunnes]

Good man......this seems like it will solve my query, i thought it was going to be alot more complicated!
I was thinking like a count amount of words (C++ programming im doing) but wasnt quite sure how i would translate into Excel, which i suppose it as as all you are looking for is a number and then a blank.....
Genius

Cheers
Mike