Multiple CountIf Statements with Wildcard *

Hello,

Can someone please help me? I am trying to take 2 CountIf statements and combine them in 1 so they both have to meet in order for it to be counted.

Here are the two statements and they do work like this.
=COUNTIF(B3:B2000,"*"&"yes"&"*")
=COUNTIF(I3:I2000,"*"&"no"&"*")

I would like to do something like:
=COUNTIF(B3:B2000,"*"&"yes"&"*") AND COUNTIF(I3:I2000,"*"&"no"&"*")

Essentially what I want is if cell B10 contains the word “yes” and cell I10 contains the word “no”, then it will count it as a 1. I do need the wildcard * in it as well because the search word could be anywhere within the text.

Thanks for any help someone can offer,

Zines

Use countifS

=COUNTIFS(B3:B2000,"*"&"yes"&"*",I3:I2000,"*"&"no"&"*")

Also, you don't need to concatenate the *'s with the words

=COUNTIFS(B3:B2000,"*yes*",I3:I2000,"*no*")

Awesome, thanks, I didn't know about the countifs with the S. That worked great. I was trying to use and right after the word countif( and couldn't get anything to work. This is perfect!

Great, glad to help out.