Sumif multiple criteria from different sheets.

[klatlap]

I am following instructions from this website Summing data across multiple criteria on multiple worksheets - Microsoft 365 Blog but i am coming up with an error here is my formula.

=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT(“‘”&Code[System]&”‘!Y:Y"),INDIRECT(“‘”&Code[System]&”‘!V:V”),$h3,INDIRECT(“‘”&Code[System]&”‘!w:w”),$l3,INDIRECT(“‘”&Code[System]&”‘!x:x”),$m3)),)

I have indicated in red where the error is

Here is another code that works fine with a single criteria.
=SUMPRODUCT(SUMIF(INDIRECT("'" & Code & "'!v:v"),H2,INDIRECT("'" & Code & "'!y:y")))


I am using office 2013 if that makes a difference

 

[GlennUK]

Why is it Code[System] in one example, and just Code in the other?