+ Reply to Thread
Results 1 to 3 of 3

Sum running total excluding filtered data

  1. #1
    Registered User
    Join Date
    11-07-2009
    Location
    NYC
    MS-Off Ver
    365
    Posts
    24

    Sum running total excluding filtered data

    I'd like to have a running total in column B based on previous row in B and adjustment amount in A. This simple application can run just on =SUM(B1,A2) and would be copied down the range to evaluate appropriate reference cells.

    A B
    0
    1 1
    2 3
    3 6

    If my filter result hides row 3 for instance (with data A:2, B:3), I need the row 4 in column B to read 4 instead of 6. I'd like the data in row 3 to be disregarded but rest of the running total to continue. I've looked into SUBTOTAL function but it seems that would not be applicable here?

    Any suggestions appreciated. Thanks

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sum running total excluding filtered data

    a1=SUBTOTAL(109,$A$3:$A$7)

    c3=SUM($A$3:$A3) and drag down (for cummulative data).
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-07-2009
    Location
    NYC
    MS-Off Ver
    365
    Posts
    24

    Re: Sum running total excluding filtered data

    Thanks for the tip.
    I ended up using =SUBTOTAL(109,$a$1:$A2) placed in B2 and copied down. A1 needed a starting value manually inserted (0 from B1).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vba code to filter data excluding running year
    By Kalpesh93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2015, 10:12 AM
  2. Replies: 4
    Last Post: 06-12-2013, 12:51 PM
  3. Drop down box data to equal zero on a running total (?)
    By BuckeyePride in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2012, 12:59 PM
  4. How do I keep a running total?-when data changes in A4
    By excelmaster5000 in forum Excel General
    Replies: 1
    Last Post: 02-26-2008, 11:00 PM
  5. How to have total for filtered data??
    By Derrick in forum Excel General
    Replies: 2
    Last Post: 03-09-2005, 11:06 PM

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