Frequently Asked Questions for Excel

• How do I drop the lowest homework score?
• Assuming you want to drop the lowest score from columns A through P, you would use either of the following formulas:

=sum(a1:p1)-min(a1:p1)
or
=sum(a1:p1)-small(a1:p1,1)
• Assuming you want to drop the lowest two score from columns A through P, you would use either of the following formulas

=sum(a1:p1)-min(a1:p1)-small(a1:p1,2)
or
=sum(a1:p1)-small(a1:p1,1)-small(a1:p1,2)
• Keep in mind that you will need to also drop two scores from the total possible points.  Assuming the you want to drop the lowest two score from columns I through Q and that each is worth a maximum of 10 points, you would use the following formula to both drop the scores and compute the percent score:

=((SUM($I9:$Q9)-MIN($I9:$Q9)-SMALL($I9:$Q9,2))/(SUM($I$7:$Q$7)-20))
The first sum adds all the columns together.  You then subtract the minimum score of the columns.  You then subtract the second lowest score of the columns using the SMALL command.