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