"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

 

[Chip Pearson]

Use the ROW() function. E.g.,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jcottam" <[email protected]>
wrote in message
news:[email protected]...

 

[Peo Sjoblom]

Please refrain from multiposting, you already got 2 answers in misc

http://www.cpearson.com/excel/newposte.htm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Harlan Grove]

Chip Pearson wrote...

Use the ROW() function. E.g.,

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

....

If you're going to use INDIRECT, don't bother with a ROW call.

=INDIRECT("RC1",0)+A2

But don't bother with the volatile INDIRECT call. Use INDEX.

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

For that matter, given the wonders of Excel's implicit range indexing,
the following works with no function calls at all.

=A:A+A2