SUMPRODUCT on multiple values

[FrankTimJr]

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"}))

 

[Don Guillett]

here is one I have been using a long time. Works just fine

=-SUMPRODUCT((ChecksC={"electricity","water","sewer","garbage"})*(ChecksD))