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

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

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