Hello all.

I want to count�*a specific�*string "Mr. Tom"�*from a column of data. I am trying the formula "COUNTIF(E1:E4,"*Mr. Tom*")" but it returns 3. My expected return�*is 4. Please�*advise.

COUNTIF.png

Thanks�*in advance.

Regards.