I guess the reason it worked beautifully was because it didn't contain a
typo, leaving out a "0".<vbg

Appreciate the feed-back.

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"altopalo" wrote in
message ...

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