"THIS" Row Reference
 

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

"THIS" Row Reference
 

=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

"THIS" Row Reference
 

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


"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

"THIS" Row Reference
 

THANKS for the help !


--
jcottam
------------------------------------------------------------------------
jcottam's Profile: http://www.excelforum.com/member.php...o&userid=33049
View this thread: http://www.excelforum.com/showthread...hreadid=530220