Copy Cell Formulal, but need one of the Cells to stay Static.

  • Thread starter Thread starter Scott Buerkley
  • Start date Start date
S

Scott Buerkley

I am copying a formula from one cell to the next. Here is the formula:
=SUM(B5,C5)

When I paste it to the next cell below it looks like this:
=SUM(B6,C6)

When I paste the formula to the cell below, I need the C5 to stay the same,
so it sould say:
=SUM(B6,C5)

What is the syntax to do this?

Thx,
Scott Buerkley
 
Scott said:
I am copying a formula from one cell to the next. Here is the
formula: =SUM(B5,C5)

When I paste it to the next cell below it looks like this:
=SUM(B6,C6)

When I paste the formula to the cell below, I need the C5 to stay the
same, so it sould say:
=SUM(B6,C5)

What is the syntax to do this?

Thx,
Scott Buerkley
Click to expand...

formula: =SUM(B5,$C$5)

Hope this helps.

Best,
Bill
 
Hi Scott
I am copying a formula from one cell to the next. Here is the formula:
=SUM(B5,C5)
When I paste it to the next cell below it looks like this:
=SUM(B6,C6)
When I paste the formula to the cell below, I need the C5 to stay the same,
so it sould say:
=SUM(B6,C5)
Click to expand...

A thumb rule: Put a dollar sign immediately in front of everything that should NOT
change, here 5:
=SUM(B6,C$5)
or
=SUM(B6,$C$5)
if you're also filling sideways.

(
However, I'd like it better if your formula was reading
=B5+C$5
)

HTH. Best wishes Harald
Followup to newsgroup only please
 
Scott

You have several correct answers to your post. Info only from me.

Add dollar($) signs to make it Absolute Reference.

=$A$1 + B1

$A1.......absolute column, relative row
A$1.......relative column, absolute row
$A$1......absolute row and column
A1........relative row and column

You can select the cell reference(A1) in the formula bar and hit F4 to cycle
through the combinations.

See Help on cell reference to learn more.

Gord Dibben Excel MVP
 
Back
Top