Ignore Blanks and Zeros

I have this,

{=ROWS($A$140:$A$249)-SUM(IF(COUNTIF($A$140:$A$249,$A$140:$A$249)=1,1,0))}

How do I exclude counting blanks and zeros?


Thanks!

Try this:

{=ROWS($A$140:$A$249)-SUM(IF(COUNTIFS($A$140:$A$249,$A$140:$A$249,$A$140:$A$249,"<>0")=1,1,0))}

Originally Posted by Alan_Bernardo

{=ROWS($A$140:$A$249)-SUM(IF(COUNTIF($A$140:$A$249,$A$140:$A$249)=1,1,0))}

How do I exclude counting blanks and zeros?

Explain what you're wanting that formula to do.