Keep the first cell when summing a column?

J

JungleJim74

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.
 
J

jlclyde

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.
Click to expand...

Put a $ infront of the 4.
Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing rows using formulas with variables 1
Autofiller Tool Help 3
Summing several IF's in a column. 3
Array Function to do a Sum of VLookUps that translate a letter gra 3
Formula Content linked to other cells formula Content 5
Comparing Text to Several Cells 4
Column sum incorrect upon subtracting 6
Alpha sorting (with a twist...?) 3

Top