jwalkerday
New Member
- Joined
- May 1, 2018
- Messages
- 18
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.
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.
Last edited: