How do I fill down keeping one cell calculation from changing in .

[Guest]

If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.

eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
others
to change as it is filled down.

Thanks, WC

 

[RagDyeR]

Look up About cell and range references in the HELP files.

And try this:

=SUM($A$2*F13-J13)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.

eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
others
to change as it is filled down.

Thanks, WC

 

[Guest]

Thanks RD for bailing out a rookie!!