I have a list numbers in a column of cells that I would like to add up.
The only constraint is that I want to output the total sum of numbers
before each cell. Lets say I have 5 in B2, 13 in B3, 1 in B4, and 8 in
B5. I want to get 5 in C2, 18 in C3, 19 in C4, and 27 in C5.
I know I can do this by creating a SUM function for each cell
(C3=SUM(B2:B3) and then C4=SUM(B2:B4) and so forth) but I have more than
50 cells, and it will be a torture by these means.
What should I use to progressively get this sum?
*** Sent via Developersdex
http://www.developersdex.com ***