Thread: SUMIF with Exception of multiple Item
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scorpvin
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote