title: Using OR & AND in COUNTIFS
body: <p>I would like to include an <code>"AND"</code> condition for one of the conditions I have in my <code>COUNTIFS</code> clause.</p>
  
  <p>Something like this:</p>
  
  <pre><code>=COUNTIFS(A1:A196;{"Yes"or "NO"};J1:J196;"Agree")
  </code></pre>
  
  <p>So, it should return the number of rows where:</p>
  
  <pre><code> (A1:A196 is either "yes" or "no") AND (J1:j196 is "agree")
  </code></pre>