=SUMPRODUCT(--(NOT(ISNA(MATCH(A2:A6,{"Red","Blue"})))),B2:B6)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scorpvin" wrote in
message ...

The basic formula for the exception of one item would look like this
=SUMIF(A2:A6,"<Red",B2:B6). How can I add except red and blue?


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile:
http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=520638