Why not use COUNTIF?

I just did a test with the following names in Column A (Smith, Smithson,
Smithers and Smit in A1 to A4.) I used the following formula:
=COUNTIF(A1:A4,"Smith")
and the result was 1 as it should be.


"dee" wrote:

Hi,

I've looked around, but can't find the answer.

I have a list and want to count all the "Smith" last names.

I also have Smithson and Smithton in my list, which returns a count of 3
instead of 1.

How do I specify that I only want names that are exactly Smith?

thanks!
--
Thanks!

Dee