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
Count.if 2
Using a value from a cell inside a formula! 5
COUNT.IF, how to include single cells 8
Simple Module for Excel 2007 in VBA 6
MACRO RUN random percentage and copy of column values 1
Count of Font Format 1
Count Values in a Range, Not Formulas 2

Top