Count if two criteria match - EXCEL formula

Question

I have this table and I would like to create a formula which would count values based on true conditions from column `A` and column `C`. Example: If in column `A` value is M (male), and in column `C` is YES, then it would count. could anyone help me with this formula?

Accepted Answer

Add the sheet name infront of the cell, e.g.:

```
=COUNTIFS(stock!A:A,"M",stock!C:C,"Yes")
```

Assumes the sheet name is "stock"

Count if two criteria match - EXCEL formula

Solution

Problem