1. ## 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. ## 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. ## 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
•