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 Year 2018 2018 2018 CODE Posting Period 1 2 3 6110000 1 1 1 6110001 1 1 1 I did something similar here with your help- https://www.mrexcel.com/forum/excel-questions/1053935-hlookup-then-check-if-flagged-result-then-return-value.html However in that one instead of month variable I had a fixed "Result" string.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sumproduct for 3 arrays/criteria

Thread starter jwalkerday
Start date Jul 11, 2018
Tags

code data month sumproduct year

jwalkerday

New Member

Jul 11, 2018

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

	Year	2018	2018	2018
CODE	Posting Period	1	2	3
6110000		1	1	1
6110001		1	1	1

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.

Last edited: Jul 11, 2018