Desperate for a solution

[colinheslop1984]

=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365",G3),INDIRECT("'"&$C$3&"'!d2:d365",A13))

This formula returns a value of '0', instead of 40

When I remove the indirect function, i.e

=SUMIFS('2019'!H2:H365,'2019'!C2:C365,"="&G3,'2019'!D2:D365,"="&A11)

I get the value 40, which is right.

Anyone who can solve that for me would be appreciated

 

[etaf]

as i said in the last post here
https://www.mrexcel.com/forum/excel-questions/1090235-sumifs-using-indirect-2.html#post5240065
this is wrong
=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365",G3),INDIRECT("'"&$C$3&"'!d2:d365",A13))

I have even created a file and loaded on dropbox for you, that is working

=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365"),G3,INDIRECT("'"&$C$3&"'!d2:d365"),A11)
Works in my sample file

or as you new formula

=SUMIFS(INDIRECT("'"&$C$3&"'!H2:H365"),INDIRECT("'"&$C$3&"'!C2:C365"),$G$3,INDIRECT("'"&$C$3&"'!D2:D365"),A13)

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1090235-sumifs-using-indirect.html#post5239950

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).