"THIS" Row Reference

Hi there,

How do you reference the row a cell exists on (dynamic)?
ex: =sum(A"thisRow" + A2)

Thanks,

John Ryan

=SUM(INDIRECT("A"&ROW()),A2)

or better

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

the latter is better because it's not volatile


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"jcottam" <jcottam.25t4ly_1144267201.8083@excelforum-nospam.com> wrote in
message news:jcottam.25t4ly_1144267201.8083@excelforum-nospam.com...
>
> Hi there,
>
> How do you reference the row a cell exists on (dynamic)?
> ex: =sum(A"*thisRow*" + A2)
>
> Thanks,
>
> John Ryan
>
>
> --
> jcottam
> ------------------------------------------------------------------------
> jcottam's Profile:
> http://www.excelforum.com/member.php...o&userid=33049
> View this thread: http://www.excelforum.com/showthread...hreadid=530220
>

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
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"jcottam" <jcottam.25t4ly_1144267201.8083@excelforum-nospam.com> wrote in
message news:jcottam.25t4ly_1144267201.8083@excelforum-nospam.com...
>
> Hi there,
>
> How do you reference the row a cell exists on (dynamic)?
> ex: =sum(A"*thisRow*" + A2)
>
> Thanks,
>
> John Ryan
>
>
> --
> jcottam
> ------------------------------------------------------------------------
> jcottam's Profile:
> http://www.excelforum.com/member.php...o&userid=33049
> View this thread: http://www.excelforum.com/showthread...hreadid=530220
>

THANKS for the help !