how to paste formula but reference a fixed cell

[Guest]

I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically incrementing).
For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
copy it to the whole row, incrementing the denominator but not the numerator
so that you would get:
sum(A1/C2) sum(A1/C3)

how would you do it?

Thanks.
hr

 

[Guest]

Enter the formula as =$A$1/C1. The $ signs make this a fixed reference,
which means that it would increment as you copy it down or across. Check
Excel help on 'absolute vs relative references.'

 

[Peo Sjoblom]

Use

=SUM($A$1/C1)

then copy


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

Yes that did the trick. Thank you both for a quick and helpful reply.