Excel formula: countifs and criteria "not blank"
Solved
lelion4
-
Mick -
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.
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
-
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