Sumproduct for 3 arrays/criteria

[jwalkerday]

Hi,

I'm trying to add a third criteria in a SUMPRODUCT FORMULA-

=SUMPRODUCT('Sheet2'!$I$17:$EU$58*('Sheet2'!$I$15:$EU$15=$B$1)*('Sheet2'!$I$16:$EU$16=B11)*('Sheet2'!$F$17:$F$59=$A$12))

So I'm trying to locate year, month and code. But I get #N/A even though no #n/a's in source data. Can you help?

Data eg
[TABLE="width: 661"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Year[/TD]
[TD]2018[/TD]
[TD]2018[/TD]
[TD]2018[/TD]
[/TR]
[TR]
[TD]CODE[/TD]
[TD][/TD]
[TD]Posting Period[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]6110000[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6110001[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

I did something similar here with your help- https://www.mrexcel.com/forum/excel...heck-if-flagged-result-then-return-value.html

However in that one instead of month variable I had a fixed "Result" string.