DCount returns incorrect Result

[Guest]

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!

 

[Guest]

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.

 

[Guest]

Hi,

I actually just found the answer after searching on the Internet, as it also
causes the same problem when using an advanced filter (which is what
dfunctions use).

I now know to put ="=smith"

Thanks in any case!