Count values that aren't blank or N/A - VBA
<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>