Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up #s in Excel
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up #s in Excel
In CELL C3, enter =SUM($B$2:B3) then drag the little black square (bottom right hand corner) down
Regards - Steve. "EQ" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up #s in Excel
You could use this in C2:
= SUM($B$2:$B2) and copy it down the rest of column C "EQ" wrote: 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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up #s in Excel
Thanks... but here's what is happening. Now everytime I put something in the first column (lest say B1), everything changes in the whole table. I'm trying to create a record of employees and their absence hours. So, if the employee in column A1 was absent today, I put the amount of hours he was out in B1. This will cause C1 to substract from the amount of hours he's allowed to use in a year. If I keep that formula, then all of my employees below the one I'm updating, will have the same record. Can I avoid this from happening, so that only the row I'm working on will be the one affected by the changes? Thanks again... *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |