count formula needed

[kelly mort]

I wanna count with these criteria:

Col A Col B Col C
Type Sex
X M
X F
Y F

So I want to count how many F are there for X How many F for Y. How many M for X etc.

Thanks in advance.
Kelly

 

[snjpverma]

For M and X use this.
=COUNTIFS(B1:B10,"M",A1:A10,"X")

Similarly you can change the M and X to get the other results.

 

[arthurbr]

Perhaps try the COUNTIFS function or eventually a Pivot Table

 

[kelly mort]

Oh okay thanks to you all for pointing me to the correct syntax.

I got confused in the process.

Thanks again
Kelly