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

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.

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

=D2/$D$9

--
Regards,

Peo Sjoblom


"kwelp" <kwelp@discussions.microsoft.com> wrote in message
news:BD9DFC19-FD17-4AE3-A575-61AB98353514@microsoft.com...
> 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.

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.

"Peo Sjoblom" wrote:

> First of all, the sum function is not necessary when you only have 2 cells
> that you divide
>
> =D2/$D$9
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "kwelp" <kwelp@discussions.microsoft.com> wrote in message
> news:BD9DFC19-FD17-4AE3-A575-61AB98353514@microsoft.com...
> > 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.
>
>

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 :>)

--
Dana DeLouis
Win XP & Office 2003


"kwelp" <kwelp@discussions.microsoft.com> wrote in message
news:8F2FC8A7-37AE-40B8-84E5-F91C2EFE8BB6@microsoft.com...
> 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.
>
> "Peo Sjoblom" wrote:
>
>> First of all, the sum function is not necessary when you only have 2
>> cells
>> that you divide
>>
>> =D2/$D$9
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>> "kwelp" <kwelp@discussions.microsoft.com> wrote in message
>> news:BD9DFC19-FD17-4AE3-A575-61AB98353514@microsoft.com...
>> > 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.
>>
>>