software

Hi there,

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

Thanks,

John Ryan--
jcottam
------------------------------------------------------------------------
jcottam's Profile: www.excelforum.com/member.php...oamp;userid=33049
View this thread: www.excelforum.com/showthread...hreadid=530220=SUM(INDIRECT(quot;Aquot;amp;ROW()),A2)

or better

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

the latter is better because it's not volatile--

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;*thisRow*quot; 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=530220
gt;
If you mean add together Cell Aof this row to A2 and copy down use (in Row
10 for example):

=A10 $A$2

If you mean sum column A from A2 to the current row try:

=SUM($A$2:OFFSET(A10,0,0))

(again in row 10 for example)

If you mean something different then post back.

--
HTH

Sandy
with @tiscali.co.ukquot;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;*thisRow*quot; 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=530220
gt;

THANKS for the help !--
jcottam
------------------------------------------------------------------------
jcottam's Profile: www.excelforum.com/member.php...oamp;userid=33049
View this thread: www.excelforum.com/showthread...hreadid=530220