How do I add consecutive numbers but start over at a break in the.

H

Hockley

How do I add consecutive numbers but start over at a break in them. I'm
trying to calculate consecutive days of attendance. One might have had 20
days in a row missed one and then I need to start over.

Thanks.
 
R

Ragdyer

Does this work for you?

Attendance starting in A1.

In B1 enter:
=--(A1>0)
In B2 enter:
=(A2>0)*(1+B1)
And drag down to copy as needed.
 
Top