Use CountIf for a literal string
 

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

Use CountIf for a literal string
 

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

Use CountIf for a literal string
 

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


"chadkwelch" wrote:

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

Use CountIf for a literal string
 

Hi,

<0.1 is a text string. If this is the only text string in the range, you
may use the following formula

=COUNTIF(C4:C9,"*")

--
Regards,

Ashish Mathur
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