Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cumulative Totals (2000)

    Last December I was involved in an exercise with our executives in prioritizing projects in a spreadsheet. There are columns that perform cumulative totaling of dollars using a formula adding dollars in cells in current row to cumulative dollars in the row above. The exercise consisted of moving projects around (cut and paste) so with each move I had to change the formulas. Very frustrating given the audience! Is there a method to accomplish this using a formula (?) whereby formulas don't have to be manually altered?

    Thanks,
    Howard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cumulative Totals (2000)

    Say that the amounts are in column C and the cumulative amounts in column D. You could use a formula like this in D3:

    =OFFSET(D3,-1,0)+OFFSET(D3,0,-1)

    and fill down as far as needed. The formula adds the cell to the left (the amount) to the cell above (the previous cumulative total). It is invariant with respect to moving rows around.

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cumulative Totals (2000)

    Thanks Hans it works like a charm.

    Howard

Posting Permissions

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