• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif problem..

I'm a bit confused.

You have some numbers stored as text and also have one number starting with '. You state no change to data set, but can these be converted to numbers?

Also, range you mention G2:K9 did you mean B3:F10?
 
Yes, its range B3:F10, please ignore G2:K9 range. and my question is count only those values which is numeric and numeric values as text only not any other text values in given range B3:F10 without any change in data.
 
Last edited:
but if numbers like >15 or <15% or 15* available in that range then it will not work. waht could be formula to handle in this case.
 
Hi to all!

The single count could be like this:
=INDEX(COUNT(1/B3:F10),)

The count with condition could be:
=INDEX(COUNT(1/(--B3:F10>15)),)

Blessings!
 
Hi John ,

I might have misunderstood , but what I think is meant is suppose the numeric values are in conjunction with non-numeric characters e.g. suppose the cell has >15 , or <15% , or 15* ; which formula will strip the cell of all non-numeric characters and use the numeric characters , if any , which remain ?

Narayan
 
Hi Ramesh,
another could be:

=SUM(IFERROR(SIGN(B3:F10),))
with CSE

But it will not cover >15 or <15% or 15* :(

Regards,
 
You must log in or register to reply here.
Back
Top