title: How to use COUNTIF and COUNTA together in Excel?
body: <p>I have a single column and I want to count how many rows do NOT contain "www." but at the same time are not blank. I have tried:</p>
  
  <pre><code>=COUNTIFS(E2:E79,"&lt;&gt;*www.*",E2:E79,"?*")
  </code></pre>
  
  <p>This seems to work, but only for text. It will not count columns if it has numbers. I have also tried:</p>
  
  <pre><code>=AND(COUNTIF(E2:E79,"&lt;&gt;*www.*"),COUNTA(E2:E79))
  </code></pre>
  
  <p>This just returns TRUE. Can someone please show me the correct formula I need to use?</p>