Newbie needs help please

[dharker]

Hi

I have an array of boxes corresponding to each day of the month, into which I enter periods of sickness/absence by marking each day off with an "S". I can then count the number of days sick quite happily. I've been asked to count the number of occasions of sickness now, for example a person could have a days sickness on the 5th then 3 days later in the month. Under these circumstances I would need a count of two PERIODS of absence along with the 4 days absence.

Could someone please help point me to the correct function or a method of doing this? I'm a newbie so have no VBA skills... (any great sources for learning VBA btw?)

Many thanks
Dave

 

[West Man]

Assuming they are in a single row and that there is a column before the first entry that is not used to indicate sickness try:


=SUMPRODUCT(--(B2:O2="s"),--(A2:N2<>"s"))

s

s

s

s

s

s

s

s

s

3

<tbody>
</tbody>

 

[dharker]

Works perfectly! Thanks West Man...
Dave

 

[West Man]

Happy to have helped