Sumproduct with Indirect Sheet Names

[mdonovan890]

I am working within Excel 2016 and I am currently using the following formula to count the number of dates equal to the week number.
=SUMPRODUCT(--(ISOWEEKNUM(A3)=ISOWEEKNUM('---General Chem---'!$E$2:$E$8000)),--(YEAR(A3)=YEAR('---General Chem---'!$E$2:$E$8000)))

This formula works however, I would like to adapt it so that my sheet names can be listed in a cell instead of hard coded.

What I have so far:
Sheet Name listed in G1
=SUMPRODUCT(--(ISOWEEKNUM(A3)=ISOWEEKNUM(INDIRECT(""&G$1&"'! !$E$2:$E$8000")),--(YEAR(A3)=YEAR(""&g$1&"'! !$E$2:$E$8000")))


This formula keeps returning as an error, could anyone tell me what I am doing wrong?

 

[Domenic]

Try...

=SUMPRODUCT(--(ISOWEEKNUM(A3)=ISOWEEKNUM(INDIRECT("'"&$G$1&"'!$E$2:$E$8000"))),--(YEAR(A3)=YEAR(INDIRECT("'"&$G$1&"'!$E$2:$E$8000"))))

Hope this helps!

 

[mdonovan890]

Amazing! Thanks so much

 

[Domenic]

You're very welcome!

Cheers!