Help with Countif

[boop]

Hi all,
In the sample data below, I need to find the number of unique codes in column A coresponding to "M" in column B. Is there a simple formula I can use? I'm using Excel 2010 if that changes anything.
A B
1 1233 M
2 4562 M
3 1233 M
4 7625 S
5 7352 S
6 4562 M
7 2447 S

Thanks!

 

[boop]

Both the COUNTIF and SUMIF functions support the use of wildcards. None of the functions in the other formula support wildcards so it was evaluating the * as the lteral asterisk character.

Great, thank you!

 

[T. Valko]

Great, thank you!

You're welcome!