Use CountIf for a literal string

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
 
A

Ashish Mathur

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Excel Countif Function - Calculating Between Two Sets of Values 3
Question using countif 11
How do I filter data by more than one column in excel 0
Using <= in countifs statement 1
countifs Function not giving desired result with date criteria 2
Countif using cell refences 4

Top