SUMIF with Exception of multiple Item
 

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

SUMIF with Exception of multiple Item
 

You could do it with three SUMs: one to total all cells, one for the red,
one for the blues:
=SUM(B2:B6)-SUMIF(A2:A6,"<Red",B2:B6)-SUMIF(A2:A6,"<Blue",B2:B6)

Andy.

"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

SUMIF with Exception of multiple Item
 

=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