consecutive value occurance count?

I have to calculate bonus payments for people working O/S. I have a 5 year calendar in month blocks (60 months/columns). In each month there is a percentage 'time O/S' figure. If an employee is O/S for 3 consecutive months they get bonus 'A', 6 consective months bonus 'B', etc.
How can I evaluate the 60 columns, returning the number of times 100% occurs in 3 consecutive months/columns.
I have found examples of similar solutions but they will return a value of 3 if there are 5 consecutive months of 100%...
ie. 100 100 100 100 100
= 100 100 100 *** ***
& *** 100 100 100 ***
& *** *** 100 100 100
= 3
but I need it to equal 1

Hope this makes sense to someone else???

Thanks...

I have 60 columns across sheet representing months

Each column has a % value.

I need to count the number of times 100% appears in 3 consecutive columns as 'A'

I also need to count the number of times 100% appears in 6 consecutive columns as 'B'

But, if 100% appears in 5 consecutive columns, I need 'A' to equal 1 (not 3), as although there are technically 3 sets of 100% values the employee has only been there for one 'A' qualifying period...

This is what I was trying to represent, the *** represented the 100% value that were not being evaluated in each of the three possible match's.

Hope that's a bit clearer, sorry it's very hard to explain

The issue I have is that in the given period an employee may qualify for ("bonus A" 12 times and "Bonus B" 3 times) or ("bonus A" 2 times and "bonus B" 6 times) or millions of other combinations thereof...

So I need to return a numeric value for each bonus that will go under a column heading "Bonus A"(Number of times: 3 consecutive months @ 100% O/S), "Bonus B"(Number of times: 6 consecutive months @ 100% O/S).

This is where I believe the difficulty comes, returning a value of 1 for five consective months 100% Overseas. The other thing is it must only count 100% O/S values as there will be many months when there are values of 10%, 25%, etc not credited toward the bonus.

for example-

100, 15, 25, 100, 100, 50, 100, 100, 5, 100, 100, 0, 100, 100, 10

where:
'A' = 0
'B' = 0

or

100, 100, 100, 100, 100, 100, 100, 100, 0, 100, 100, 100, 100, 100, 10

where:
'A' = 1
'B' = 1

or

0, 0, 0, 0, 0, 0, 25, 50, 75, 100, 100, 75, 50, 75, 100, 100, 100, 100

where:
'A' = 1
'B' = 0

Hope this makes a bit more sense now...(sure know I'm confused)

Regards,
David

I modified the previous function to do what you need.

Regards,
Antonio

See attached file where I inserted 'bonus' function... I hope it can help.

Regards,
Antonio