Keeping one part of a formula same, but change other cell ref?

K

kwelp

How do I keep one part of a cell formula the same, but change the other
referenced cell? Example: =sum(D2/D9) where D9 stays the same, but D2 will
change to D3, D4, etc.
 
P

Peo Sjoblom

First of all, the sum function is not necessary when you only have 2 cells
that you divide

=D2/$D$9
 
K

kwelp

thank you, couldn't remember the "$" sign to keep a cell reference constant.
I am using more than two cells, a whole list as a matter of fact.
 
D

Dana DeLouis

You may want to know about the F4 button as well. As you finish typing
"D9", hit the F4 button to cycle thru the options. It will place the "$" in
the cell address for you. HTH :>)
 
Top