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]...
>
> 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
>

[drizzt04240]

Thank you very much, that worked great.