software

Hi there,

How do you reference the row a cell exists on (dynamic)?
ex: =sum(Aquot;thisRowquot; A2)

Thanks,

John Ryan--
jcottam
------------------------------------------------------------------------
jcottam's Profile: www.excelforum.com/member.php...oamp;userid=33049
View this thread: www.excelforum.com/showthread...hreadid=530221Use the ROW() function. E.g.,

=SUM(INDIRECT(quot;Aquot;amp;ROW()) A2)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;jcottamquot; gt;
wrote in message
...
gt;
gt; Hi there,
gt;
gt; How do you reference the row a cell exists on (dynamic)?
gt; ex: =sum(Aquot;thisRowquot; A2)
gt;
gt; Thanks,
gt;
gt; John Ryan
gt;
gt;
gt; --
gt; jcottam
gt; ------------------------------------------------------------------------
gt; jcottam's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33049
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=530221
gt;
Please refrain from multiposting, you already got 2 answers in misc

www.cpearson.com/excel/newposte.htm--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;jcottamquot; gt; wrote in
message ...
gt;
gt; Hi there,
gt;
gt; How do you reference the row a cell exists on (dynamic)?
gt; ex: =sum(Aquot;thisRowquot; A2)
gt;
gt; Thanks,
gt;
gt; John Ryan
gt;
gt;
gt; --
gt; jcottam
gt; ------------------------------------------------------------------------
gt; jcottam's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33049
gt; View this thread: www.excelforum.com/showthread...hreadid=530221
gt;
Chip Pearson wrote...
gt;Use the ROW() function. E.g.,
gt;
gt;=SUM(INDIRECT(quot;Aquot;amp;ROW()) A2)
....

If you're going to use INDIRECT, don't bother with a ROW call.

=INDIRECT(quot;RC1quot;,0) A2

But don't bother with the volatile INDIRECT call. Use INDEX.

=INDEX(A:A,ROW()) A2

For that matter, given the wonders of Excel's implicit range indexing,
the following works with no function calls at all.

=A:A A2