title: Count/Sum a column but exclude #N/A
body: <p>Currently using the following forumlas to count the number of records in all of column Z that does not have #N/A but it does not work. All the rows in Column Z have a formula itself (Which is why some of them display #N/A, its a VLOOKUP).</p>
  
  <pre><code>=COUNTA(Z:Z)-SUM(IF(ISNA(Z:Z),1))
  =SUMPRODUCT(--(TRIM(Z:Z)&lt;&gt;"#N/A"))
  </code></pre>
  
  <p>These return a "0" value which is not true, what am I doing incorrect?</p>
  
  <p><a href="https://i.stack.imgur.com/SD6Mw.gif" rel="noreferrer"><img src="https://i.stack.imgur.com/SD6Mw.gif" alt="enter image description here"></a></p>