title: Calculate the average of the 3 highest grades
body: <p>I'm relatively new to excel but I am making a gradebook that calculates all of my grades.</p>
  
  <p>One of my classes has an interesting way to calculate grades. There are 4 quizzes, and the lowest one will be dropped (essentially removed from the calculation completely).</p>
  
  <p>How would I go about this, I tried using </p>
  
  <pre><code>=((SUM(D2:D5)-SUM(SMALL(D2:D5,4)))/(COUNT(D2:D5)*100))
  </code></pre>
  
  <p>on data like this</p>
  
  <pre><code>D2|75
  D3|80
  D4|83
  D5|65
  </code></pre>
  
  <p>So in this case, I want the 65 to be removed, then calculate the average</p>
  
  <p>I am not getting any error but the average is wrong</p>