Adding but "compounding"? the totals in a column
I can't figure out how to do this except for the very long way. I have a column of about 100 numbers that I want to add. That I can do simply enough, however instead of just showing the final total at the bottom I want to show each step of the way. For example if I'm adding a column of 5 5's in the column next to it i would like to show 5,10,15,20,and lastly 25 at the end. Besides creating a seperate SUM function including the last cell, last two cells, last three cells.....and so on is there a short way of doing this?
Thank you in advance
Attachment | Size |
---|---|
RunningSum.xls | 17 KB |
- Geek's blog
- Login or register to post comments
- 3087 reads
Adding but "compounding" the totals in a column
Nick you are the man! It works like a charm, thank you!
running sum
try this: RunningSum.xls
adding columns........
Nick it worked perfectly! thank you!