title: Excel formula for count cells if not null, invalid or 0
body: <p>I have a formula that I want to use to check if a cell does not have an 'invalid' value in it. However, it is also counting empty cells, and cells that have anything in it that isn't equal to zero:</p>
  
  <pre><code>=COUNTIF(A2:A200,"&lt;&gt;0")
  </code></pre>
  
  <p>This only checks if the cell does not have a value of "0". What can I add to it so that it will not count empty cells, or cells with values like:</p>
  
  <pre><code>#######
  VALUE?
  r
  </code></pre>
  
  <p>etc. All I want is to count how many cells have a number in them that does not equal 0, or an error.</p>