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?

question from:https://stackoverflow.com/questions/10158675/count-if-two-criteria-match-excel-formula

Answer 1

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"