Thank you!!!!


=SUMPRODUCT((ISNUMBER(SEARCH("MC",B32:B1000)))*(C3 2:C1000="P1"))

worked beautifully


--
altopalo
------------------------------------------------------------------------
altopalo's Profile: http://www.excelforum.com/member.php...o&userid=25276
View this thread: http://www.excelforum.com/showthread...hreadid=387679