INDIRECT Formula does not like tab names

[thbutterflycollector_]

Hi,

I have the following formula:

=SUMIF(INDIRECT$D9&"!$G210:G300"),"Months",INDIRECT(D$9&"!F210:F300")))

The tab names are a mixture of letters and numbers e.g. "05.1.1 Stage 3 (2)"

Column D contains the Sheet Name - the formula only seems to work when I change it to a text value. I have tried a ' at the front of the cell value in Column D to no avail.

Any ideas on what the blocker might be?

 

[Fluff]

How about

=SUMIF(INDIRECT("'"&$D9&"'!$G210:G300"),"Months",INDIRECT("'"&D$9&"'!F210:F300"))

 

[thbutterflycollector_]

How about

=SUMIF(INDIRECT("'"&$D9&"'!$G210:G300"),"Months",INDIRECT("'"&D$9&"'!F210:F300"))

Thank you (again!) Fluff. Problem solved.

Just out of interest what did the formula not like?

 

[Fluff]

You were missing an opening bracket for the 1st indirect & you didn't have the ' before & after the cell reference for the sheet name.