Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep the first cell when summing a column?
How do I keep the first cell when copying the formula to successive cells?
For example: I want to sum all the values in column B starting with cell B4 through and including B12 and I want the cell B4 to stay the same in all succeeding formulas. When I paste the formula into successive cells it changes the formula to =SUM(B5:B12). Thank you in advance for any help. -- JungleJim74 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
Summing cells within a column based on cell fill color | New Users to Excel | |||
Summing a column based on input in a cell | Excel Discussion (Misc queries) | |||
summing column c based an column a criteria | Excel Worksheet Functions | |||
Summing every other cell in a column? | Excel Worksheet Functions |