title: How to count cells that only contain the VALUE 0 and not the result of a formula?
body: <p>For the following sheet:</p>
  
  <pre><code>    A
  1   0
  2   0 as formula result
  3   0
  4   0 as formula result
  5   0 as formula result
  6   blank
  7   0
  </code></pre>
  
  <p>How do I count only the cells with <code>0</code> entered as VALUES and not the cells with <code>0</code> as their formula result, i.e.</p>
  
  <p><code>COUNTIF(A1:A7,0 AS VALUE)</code> = 3</p>
  
  <p>I've tried the following:</p>
  
  <p><code>COUNTIF(A1:A7,0)</code> = 6</p>
  
  <p><code>COUNTIF(A1:A7,"0")</code> = 6</p>