Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How do I add consecutive numbers but start over at a break in the. | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Inventory numbers - Consecutive, but out of sequence | Excel Discussion (Misc queries) |