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

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.

Does this work for you?

Attendance starting in A1.

In B1 enter:
=--(A10)
In B2 enter:
=(A20)*(1+B1)
And drag down to copy as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Hockley" wrote in message
...
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.