title: How do I get countifs to select all non-blank cells in Excel?
body: <p>How do I get <code>countifs</code> to select all non-blank cells?
  I have two other criteria, so using <code>counta</code> alone is not an option.</p>
  
  <p>Using <code>istext</code> makes the result give 0, always.
  Excel gives an error when using  <code>&lt;&gt;""</code>  as a criterion.</p>