=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" wrote in
message ...

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