title: Count all fields in an column, except for n specified range
body: <p>I am trying to count all the field in an entire column except for n specified range. I need to select the entire column to cater for future expansion</p>
  
  <p>currently i am trying:</p>
  
  <pre><code>=COUNTIF(B:B,"&lt;&gt;ASY999 OR &lt;&gt;ASY002 OR &lt;&gt;CIB001 OR &lt;&gt;""")
  </code></pre>
  
  <p>But the formula still counts the blank cell at the bottom of the column I get a return value of 65536 which is not correct</p>