Use CountIf for a literal string

  • Thread starter Thread starter chadkwelch
  • Start date Start date
C

chadkwelch

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
 
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,"*")
 
Back
Top