Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
a cell reference in a 3d reference | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |