Cell Address Location

[drizzt04240]

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

 

[Bob Phillips]

=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" <[email protected]>
wrote in message
news:[email protected]...

 

[drizzt04240]

Thank you very much, that worked great.