title: what formula is needed to count two specific cells that already include a formula
body: <p>Afternoon all,</p>
  
  <p>I am trying to create an enquiry managment spreadsheet that records all incoming enquires and what has been done to date.</p>
  
  <p>I am trying to get a cell to count how many "New" enquiries David has.</p>
  
  <p>Daivds name is populated via a drop down list and the number of enquiries is counted via the text "NEW" selected from a drop down list.</p>
  
  <p>The formula as I understand it should be along the lines of</p>
  
  <pre><code> =COUNTIF(Enquiries!E4:E309,"NEW")=IF(Enquiries!B4:B309,"DAVID")
  </code></pre>
  
  <p>But i cannot for the life of me get it to work!!</p>
  
  <p><a href="https://i.stack.imgur.com/TDcms.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TDcms.png" alt="Snippet of spreadsheet"></a></p>