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

  • Thread starter Thread starter Ben
  • Start date Start date
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
 

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
Populate cell with multiple non-blank text values 3
Offset and Small functions with blank rows? 0
Simple Module for Excel 2007 in VBA 6
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Back
Top