Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Accumulative sum (2K3)

    I am having a logic block about accumulation of totals.
    Column A = Distance in Miles
    Column B = Elevation
    Column C = Accumulated Ascent
    Column D = Accumulated Descent

    As you can imagine over a period of miles the Elevation will go up and down, depending on your training requirements for that run it is sometimes good to see the accumulated rise/descent of the entire run.

    In Column C (Ascent) I have, starting at C3 the following formula:

    =IF(B3>B2,(B3-B2)+C2,0)

    This accumulates the value OK until it reaches a cell (C[n]) where C[n-1] is zero and the accumulation restarts from zero

    Question is how can I keep the accumulation going up without resetting? Workbook attached
    Jerry

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Accumulative sum (2K3)

    I have found a work around by adding a new column D and inserting this formula =C3+D2 in D3 and copying down, seems to work and enough to chart but would be good to see a formula <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Accumulative sum (2K3)

    How about this version, uses MAX & MIN

    ps I hope this is not a circular route you are running, if so you ended up underground <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Attached Files Attached Files

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Accumulative sum (2K3)

    Yep, that'll do nicely. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Making <img src=/S/note.gif border=0 alt=note width=20 height=20> to self to work on the MIN and MAX stuff more
    Jerry

Posting Permissions

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