Cell Address Location
 

Hello,

I am using the below formula to create the address of a cell range that
i need to sum. Unfortunately it does not see the address as an address.
How do i use the the ouput of this formula in a sum formula.

="'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec
05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec
05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26)

Output:

'Dec 05'!$V$6:$Z$6

Thanks,

Chris


--
drizzt04240
------------------------------------------------------------------------
drizzt04240's Profile: http://www.excelforum.com/member.php...o&userid=29264
View this thread: http://www.excelforum.com/showthread...hreadid=489822

Cell Address Location
 

=SUM(INDIRECT("'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec
05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec
05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"drizzt04240"
wrote in message
...

Hello,

I am using the below formula to create the address of a cell range that
i need to sum. Unfortunately it does not see the address as an address.
How do i use the the ouput of this formula in a sum formula.

="'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec
05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec
05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26)

Output:

'Dec 05'!$V$6:$Z$6

Thanks,

Chris


--
drizzt04240
------------------------------------------------------------------------
drizzt04240's Profile:
http://www.excelforum.com/member.php...o&userid=29264
View this thread: http://www.excelforum.com/showthread...hreadid=489822

Cell Address Location
 

Thank you very much, that worked great.


--
drizzt04240
------------------------------------------------------------------------
drizzt04240's Profile: http://www.excelforum.com/member.php...o&userid=29264
View this thread: http://www.excelforum.com/showthread...hreadid=489822