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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
=--(A1>0)
In B2 enter:
=(A2>0)*(1+B1)
And drag down to copy as needed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add consecutive numbers but start over at break in the. 3
Continuous page numbering when printing whole book 2
Count Number Of Times Values Appears Consecutively, Return Longest 5
Counting strings of consecutive numbers in a column 1
how do i print a page of consecutive numbers 3
Excel Consecutive counts with conditions in excel 0
Adding Consecutive Entries 1
How do I in excel print consecutive numbers from one form? 1

Back
Top