Just use a wildcard to make Excel treat the criteria as text...

Try this
=COUNTIF(A1:A10,"010020*")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)




"c mateland" wrote in message
oups.com...
Excel 2003

I'm trying to do a simple countif. In column A, I have...

A
010020
010020
010020
010020
10020
10020

In another cell, I have =COUNTIF(A:A,"010020"), which results in 6,
when I expect 4. It's counting the 10020 entries as well. I want an
exact match to the literal criteria I enter.

How do I do that?

Thanks,
Chuck