title: How do I get a count of IDs based on if they meet certain criteria/outcome?
body: <p>I'm faced with the following issue in Excel.  I want to get a count of students who failed 100% of their classes (earned either a D, F, No pass, or Withdrew) that they enrolled in during a semester.  What is a formula that can help count this?</p>
  
  <p>The data is organized as the following:</p>
  
  <p><a href="https://i.stack.imgur.com/rAjAI.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rAjAI.jpg" alt="ExcelData"></a></p>
  
  <p>I tried IF statements but I'm having trouble writing a formula that takes into account the condition that the student would need to have failed ALL of their classes that they enrolled in.  Some students enrolled in just one course and others enrolled in several.</p>
  
  <p>I could manually count this but this would take too long considering there are over 15,000 rows of data.  </p>
  
  <p>I'm hoping to get a count of students who meet this requirement among 6,000 students (15,000 rows of data).</p>
  
  <p>Any help is much appreciated</p>
  
  <p>Thank you</p>