Hi Tony,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"tony h" <tony.h.1t6tav_1123070750.1562@excelforum-nospam.com> wrote in
message news:tony.h.1t6tav_1123070750.1562@excelforum-nospam.com...
>
> I have a workbook with a Summary sheet and then a series of sheets for
> each month/year. Onthe summary sheet I use column A for the month/year
> as a date formatted "mmm yy" ie the same as the sheet names.
>
> in columns B,C,D I want formulae that sums or averages a fixed range
> on each sheet but I would like the formula to take the sheet name from
> Columa A rather than hard coding it.
>
> So that in the example =SUM('Dec 04'!$C$6:$C$47) I want to take the
> "Dec 04" from the text in cell A3
>
> Many thanks,
>
>
> --
> tony h
> ------------------------------------------------------------------------
> tony h's Profile:
> http://www.excelforum.com/member.php...o&userid=21074
> View this thread: http://www.excelforum.com/showthread...hreadid=392470
>