+ Reply to Thread
Results 1 to 4 of 4

Running Total

  1. #1
    Registered User
    Join Date
    04-05-2011
    Location
    NC USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Cool Running Total

    Running Total (Trying again)


    ____A__________B____________C___________D
    1___3__________2____________5___________5
    2___4__________5____________9___________14
    3___2__________5____________7___________21
    4_______________________________________21
    5_______________________________________21
    6_______________________________________21
    7_______________________________________21
    8_______________________________________21


    I do not want anything in cell D4 untill I put a vaule in cell A4 & B4.
    The last number in cell "D" keeps repeating itself untill I put a number

    in cell A4 & B4 .Is there a formula I can put with the running
    total formula to fix that

  2. #2
    Forum Contributor
    Join Date
    09-18-2008
    Location
    Scotland
    Posts
    156

    Re: Running Total

    can you attach a copy of your spreadsheet here (with sensitive material removed), it will make it easier for the gurus to answer.

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Running Total

    Try:

    =IF(C1="","",SUM(C$1:C1))

    copied down
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    04-08-2011
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Running Total

    i would do multiple checks
    like in e2 i would check =if(a2>0,1,0) wich would bring back a result of 1 if it has any value at all.else 0...then do the same in f2 for b2 ...then add the 2 together in g2
    so now if we go back to d2 we could say if g2=2,d1+c2,0
    wich is to say if g2 = 2 then add them up else just return zero...
    theres probably a better way to do it but that would return a value of zero instead of continuing
    with the last value like you have in your example


    Quote Originally Posted by bohogger View Post
    Running Total (Trying again)


    ____A__________B____________C___________D
    1___3__________2____________5___________5
    2___4__________5____________9___________14
    3___2__________5____________7___________21
    4_______________________________________21
    5_______________________________________21
    6_______________________________________21
    7_______________________________________21
    8_______________________________________21


    I do not want anything in cell D4 untill I put a vaule in cell A4 & B4.
    The last number in cell "D" keeps repeating itself untill I put a number

    in cell A4 & B4 .Is there a formula I can put with the running
    total formula to fix that

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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