how to sum or count values with "<" symbol in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to report values as "<x" such as <0.1 , but want to assign a value of
zero when performing mathematical equations, and want to be able to count
them separately from values that don't have "<". I'm looking for syntext in
the formulas that will help me do this. Please help. Thanks!
 
While the string may look like an emoticon, you would actually use this to count them:

=COUNTIF(B:B,"*<*")

Or to create an extra column for doing the math:

=IF(ISNUMBER(FIND("<",B2)),0,B2)

copied down to match your values, then use that for averaging, etc.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
0.1 to 0.99 not recognised or calculated when results from formula 5
Excel formula, sum the value cell and if empty cell left blank 0
Access count a field in access report 2
Help in counting and summing cells based on multiple conditions 9
Sum or Count using set range 3
Count Unique Values 4
How do I sum cells that have values from a text formula? 4

Back
Top