how to use "<10" as text value instead of numeric in COUNT.IF()

B

Ben

Hi,

With the function =COUNT.IF(a1:a10;"<10"), i'll get the number of cells
with value less than 10.
But suppose there are cells which contain the text value "<10" (as a code
e.g.). How can i use COUNT.IF() function to count the number of those cells?

Thanks
Ben
 
D

Dave Peterson

How about a different function?

In the USA version:

=SUMPRODUCT(--(A1:A10="<10"))
 
Top