SUMPRODUCT on multiple values
I attempted to use the multiple criteria as in:
=SUMPRODUCT(--(A1:A10={"Ford","Chrysler"}))
but the result returns #VALUE!
Also, assuming I can get this to work, does this also work for < (Not equal
to)? So the formula would be:
=SUMPRODUCT(--(A1:A10<{"Ford","Chrysler"}))
|