Indirect value for a sheet name

[USAMax]

I have looked at a dozen pages and I cannot understand why this is not working.

The INDIRECT range on the left should be exactly the same as the range on the right but I am getting #REF !.

=SUMIF(INDIRECT("'" & A11 & "'!" & AM2:AM5000), ">0", 'West Creek'!AM2:AM5000)

The value in Cell A11 is, "West Creek".

My goal is to copy this cell in the overview page to lookup values in other worksheets.

 

[Fluff]

Try
=SUMIF(INDIRECT("'" & A11 & "'!AM2:AM5000"), ">0", 'West creek'!AM2:AM5000)

 

[USAMax]

Thanks Fluff! I don't know if it is my head cold or stupidity that I missed this but I very much appreciate you help!

 

[Fluff]

You're welcome & thanks for the feedback