+ Reply to Thread
Results 1 to 2 of 2

Adding Consecutive Entries

  1. #1
    FLKULCHAR
    Guest

    Adding Consecutive Entries

    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

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1