Count Data using multiple critea 1 formula excel

0
votes

i have table excel like this

enter image description here

i want to know, how to count data parameter Nationality Singaporean and Gender "Male"

i'm try formula like this => =COUNTIFS(A2:C6,{"Male","Singaporean"}) this result 3 it's wrong result because result it's 2

Help me thank's

1
excelexcel-formula

1 Answers

4
votes

Untested but 

=COUNTIFS(B2:B6,"Singaporean", C2:C6, "Male")

should work