title: Excel countifs with multiple conditions
body: <p>I'm trying to count all the people in an excel file that scored less than 75 on exam 1 but scored over 900 on either exam 2 OR 3. I tried using <code>countifs</code> but if both exam 2 and exam 3 are over 900, it counts them twice. Any suggestions? Please help!</p>
  
  <p>I've tried <code>sumproduct</code> as well but I can't figure out how to include an <code>OR</code> condition that's based on 2 separate columns</p>
  
  <pre><code>=COUNTIFS($C:$C, "&lt;75",$E:$E,"&gt;900",$F:$F,"&gt;900")
  </code></pre>
  
  <p>I would expect to keep a count of all the students that meet this criteria.</p>