Adding Consecutive Entries

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

Guest

In column a, I have a list of numbers...

I wish to add the number of consecutive entries...then start over when there
is a blank (no entry) in my column A cell.

How is this done??

I believe it has something to do with the boolean -- test...(minus, minus).

Please advise,

FLKulchar
 
This will generate a running total in column B, restarting after a blank
cell in Col. A

(your data should begin in row 2 with row blank)
Enter this in B2 and copy down the range of your data in A:

=IF(A1="",A2,IF(A2="","",B1+A2))

Does this work for you?

Bruce
 
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

Any (6) consecutive entries 4
Alphabetical Order (check for duplicates) 7
FINDING "EQUALITY" within 3 consecutive columns 5
need formula? to include blank cells in "running balance" 5
I want to align some entries in consecutive rows like Word tabs 3
Count Number Of Times Values Appears Consecutively, Return Longest 5
Consecutive No'ing WHEN ADDING/DELETING ROWS 2
Excel Count of Consecutive Data 0

Back
Top