Excel formula: countifs and criteria "not blank"

Solved
lelion4 -  
 Mick -
Hello,

I am using Excel 2007, and I have been looking for some time to introduce a criterion in my COUNTIFS formula to eliminate empty cells. I tried <>"", but it shows me an error.
I know that the quotes in some formulas are reversed, but "<>""" or "<>"" " does not work either. If I just leave "<>", I do not get the correct results.
If someone can help me define this criterion, it would help me a lot.

Thank you in advance.

5 answers

  1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    in principle:
    if the result of the formulas is not numeric and only in this case:
    • COUNTIF(range,"<>")
      counts all cells that have a formula, even if they return ""
    • COUNTIF(range,"<>")
      counts only the cells with a formula that return a text value


    If the result of the formulas is numeric it is better to use a result like "0" instead of 0 and in this case
    • COUNTIF(range,"<>")
      counts only the "0" values and the texts


    26
    1. Jacko
       
      Big thanks for your help!!!
      0
    2. Mao
       
      After 30 minutes of searching by myself, it was solved in 2 seconds with your suggestion! Great!
      0
    3. Mick
       
      3 years after this advice is still useful and has saved us all a lot of time, thank you Vaucluse.
      0