Hi

I created the following formula in the hope that it would count the number
of cells with M as an entry:

=COUNTA(F3:F100,"m")

It is returning an answer of 8 but I know there are only 3 M cells in the
column. Any ideas what I've done wrong?

Thanks