"THIS" Row Reference

[jcottam]

Hi there,

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

Thanks,

John Ryan

 

[Peo Sjoblom]

=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

 

[Sandy Mann]

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
[email protected]
[email protected] with @tiscali.co.uk

 

[jcottam]

THANKS for the help !