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.
|