i have table excel like this
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