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

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

"FrankTimJr" wrote in message
...
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"}))