Geek's blog

Data Validation with Formula

I think I posted this in the wrong place earlier....sorry for the confusion

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

Syndicate content