Using OR & AND in COUNTIFS

Question

I would like to include an `"AND"` condition for one of the conditions I have in my `COUNTIFS` clause. Something like this: ``` =COUNTIFS(A1:A196;{"Yes"or "NO"};J1:J196;"Agree") ``` So, it should return the number of rows where: ``` (A1:A196 is either "yes" or "no") AND (J1:j196 is "agree") ```

Accepted Answer

You could just add a few `COUNTIF` statements together:

```
=COUNTIF(A1:A196,"yes")+COUNTIF(A1:A196,"no")+COUNTIF(J1:J196,"agree")
```

This will give you the result you need.

EDIT

Sorry, misread the question. Nicholas is right that the above will double count. I wasn't thinking of the `AND` condition the right way. Here's an alternative that should give you the correct results, which you were pretty close to in the first place:

```
=SUM(COUNTIFS(A1:A196,{"yes","no"},J1:J196,"agree"))
```

Using OR & AND in COUNTIFS

Solution

Problem