COUNTIF - Multiple conditions are true

**ryanw327** · 11-24-2010, 08:14 PM

Hello,

I'm trying to count a range of text if the range of text meets two condition.

Please Login or Register  to view this content.

Any suggestions on how I can do this would be awesome!

Thanks in advance

**Richard Buttrey** · 11-24-2010, 08:22 PM

Hi,

If you're using Excel 2003 try,

Please Login or Register  to view this content.

change the 1:1000 range to suit your circumstances. If you have Excel 2007/2010 then use the new COUNTIFS() function.

HTH

**martindwilson** · 11-24-2010, 08:24 PM

=SUMPRODUCT(ISNUMBER(SEARCH("*WD*1*",F1:F100))*(I1:I100="ryan"))

**ryanw327** · 11-24-2010, 08:28 PM

Originally Posted by martindwilson

=SUMPRODUCT(ISNUMBER(SEARCH("*WD*1*",F1:F100))*(I1:I100="ryan"))

Works like a charm. Thank you very much

**ryanw327** · 11-24-2010, 08:32 PM

Originally Posted by Richard Buttrey

Hi,

If you're using Excel 2003 try,

Please Login or Register  to view this content.

change the 1:1000 range to suit your circumstances. If you have Excel 2007/2010 then use the new COUNTIFS() function.

HTH

This did not work for me I added the "" after WD*1*, still nothing. Says I have 0.

Thanks just the same.

Re: COUNTIF - Multiple conditions are true