Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding in excel | Excel Discussion (Misc queries) | |||
Adding with excel | Excel Discussion (Misc queries) | |||
Adding in Excel | New Users to Excel | |||
Adding in Excel | Excel Discussion (Misc queries) | |||
Adding on excel | New Users to Excel |