Try this:

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

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



"altopalo" wrote in
message ...

Hi -

I have a worksheet that has bug titles in column B and priority in
column C.

We have developed standard naming conventions for the bug title. For
example:

- MC: the Member Center has a bad help link in the header
- FP: the Front Page has a broken image in the header

I want to get a count of the bugs that contain a sub string of the
title (e.g. "MC" or "FP") and also have a certain Priority level in
column C.

I've tried these without success:

=SUMPRODUCT((B32:B1000="MC")*(C32:C1000="P1"))
=SUMPRODUCT((B32:B1000="*MC*")*(C32:C1000="P1"))
=SUMPRODUCT((B32:B1000=*MC*)*(C32:C1000="P1"))
=SUMPRODUCT((B32:B1000,*MC*)*(C32:C1000="P1"))

Any help would be greatly appreciated!!


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