Try this...

=SUMPRODUCT(--(A1:A10="<0.1"))

--
Biff
Microsoft Excel MVP


"chadkwelch" wrote in message
...
I am trying to count the number of cells in a range that contain the string
<0.1. I don't want the number of cells that contain numbers less than 0.1,
I
want the actual string. Is there an escape character for comparison
operators
like the tilde for wild cards?

Thanks,
Chad