| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep the first cell when summing a column?
On Sep 11, 12:26*pm, JungleJim74 (donotspam)
wrote: 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 Put a $ infront of the 4. Jay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep the first cell when summing a column?
Try
=sum($B$4:$B12) JungleJim74 wrote: 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. -- Message posted via http://www.officekb.com |
| Reply |
| 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 | |||
Hybrid Mode
