title: Count values that aren't blank or N/A - VBA
body: <p>I had figured out this formula to count all those values that weren't blank, but the system updated the template and now besides blank it has also "N/A" values.</p>
  
  <p>How can I transform this</p>
  
  <pre><code>=COUNTIF('R Plan'!XT2:XT3658,"&lt;&gt;")
  </code></pre>
  
  <p>To test if besides NOT blank also test for NOT N/A</p>
  
  <p>Because I tried this</p>
  
  <pre><code>=COUNTIF('R Plan'!XT2:XT3658,"&lt;&gt;" OR "&lt;&gt;N/A")
  </code></pre>
  
  <p>and I'm getting a message that we found an error on your formula</p>