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

[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

 

[Dave Peterson]

How about a different function?

In the USA version:

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

 

[Don Guillett]

try
=SUMPRODUCT((A1:A11="<10")*1)

 

[Earl Kiosterud]

Ben,

=COUNTIF(A1:A10,"=<10")

 

[Ben]

of course, thanks ...

Ben,

=COUNTIF(A1:A10,"=<10")