Hi,

Your formula is counting non-blank cells in the range 'and' A27 hence the
answer 23

try this

=COUNTIF(D1:D22,"="&A27)

Mike

"Jeremy" wrote:

=COUNTA(D1:D22,"=A27")

In the above formula I believe I am counting the number of instances the
name in A27 appears in the list from D1 to D22.

In the actual list the name in A27 actually only appears once, but the
formula is telling me it appears 23 times.

I think I am not doing something right.

Please help