software

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
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.'

quot;HRquot; wrote:

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

Use

=SUM($A$1/C1)

then copy--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;HRquot; gt; wrote in message
...
gt; I'm trying to paste a formula to a row, have the formula reference the
gt; current cell as well as a fixed cell (instead of automatically
gt; incrementing).
gt; For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
gt; copy it to the whole row, incrementing the denominator but not the
gt; numerator
gt; so that you would get:
gt; sum(A1/C2) sum(A1/C3)
gt;
gt; how would you do it?
gt;
gt; Thanks.
gt; hr
gt;
gt;Yes that did the trick. Thank you both for a quick and helpful reply.

quot;bpeltzerquot; wrote:

gt; Enter the formula as =$A$1/C1. The $ signs make this a fixed reference,
gt; which means that it would increment as you copy it down or across. Check
gt; Excel help on 'absolute vs relative references.'
gt;
gt; quot;HRquot; wrote:
gt;
gt; gt; I'm trying to paste a formula to a row, have the formula reference the
gt; gt; current cell as well as a fixed cell (instead of automatically incrementing).
gt; gt; For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
gt; gt; copy it to the whole row, incrementing the denominator but not the numerator
gt; gt; so that you would get:
gt; gt; sum(A1/C2) sum(A1/C3)
gt; gt;
gt; gt; how would you do it?
gt; gt;
gt; gt; Thanks.
gt; gt; hr
gt; gt;
gt; gt;