Geek's blog
Data Validation with Formula
Submitted by Geek on 31 March, 2012 - 16:05I think I posted this in the wrong place earlier....sorry for the confusion
Adding but "compounding"? the totals in a column
Submitted by Geek on 22 January, 2012 - 15:51I 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
- 3 comments
- 3093 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago