title: EXCEL data counting
body: <p>I currently have this formula that counts data from cells in <code>Column B and C</code>. I need to amend the formula so it won't count if a cell in <code>column D</code> is displaying the word <code>"N/A"</code></p>
  
  <p>As you can see in the example sheet, "L03" in the table is being counted as "4" however this needs to be zero as <code>N/A</code> is being displayed in column D against code "L03"</p>
  
  <pre><code>=COUNTIFS(B:B,"1",C:C,"L01")
  </code></pre>
  
  <p>The above code is what I have to count everything - I have tried everything and not getting anywhere. Please Help.</p>
  
  <p><a href="https://i.stack.imgur.com/ADaq4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ADaq4.png" alt="enter image description here"></a></p>