M
Marcotte A
I am using a sumproduct formula with 3 arguments and it works fine.
=SUMPRODUCT(--($A$2:$A$1000=I$1),--($B$2:$B$1000=$H2),$C$2:$C$1000)
when I added a fourth argument, I get a #N/A error.
=SUMPRODUCT(--($A$2:$A$1000=AE$1),--($B$2:$B$1000=$H3),$C$2:$C$1000,--($F$2:$F$1000="Fresh"))
Column F holds a Vlookup formula that returns either "Fresh" or "Ext".
Is there a limit on the number of arguments you can use with sumproduct and "--"?
=SUMPRODUCT(--($A$2:$A$1000=I$1),--($B$2:$B$1000=$H2),$C$2:$C$1000)
when I added a fourth argument, I get a #N/A error.
=SUMPRODUCT(--($A$2:$A$1000=AE$1),--($B$2:$B$1000=$H3),$C$2:$C$1000,--($F$2:$F$1000="Fresh"))
Column F holds a Vlookup formula that returns either "Fresh" or "Ext".
Is there a limit on the number of arguments you can use with sumproduct and "--"?