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

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

How to count cells with conditional formatting 3
Populate cell with multiple non-blank text values 4
Using a value from a cell inside a formula! 5
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Count.if 2
Convert numerals 1
How do I use "column" function to get the column number of the firstcell matching criteria? 2
Count Values in a Range, Not Formulas 2

Top