I am trying to do a grade worksheet. I am looking for the formula for dropping the lowest grade
D dove Nov 28, 2006 #1 I am trying to do a grade worksheet. I am looking for the formula for dropping the lowest grade
D Dave F Nov 28, 2006 #2 =SUM(A1:A5)-MIN(A1:A5) would drop the lowest grade from that range, if you want to sum. Ex.: A1 = 100 A2 = 100 A3 = 100 A4 = 100 A5 = 99 =SUM(A1:A5)-MIN(A1:A5) --> 499 - 99 = 400 Dave
=SUM(A1:A5)-MIN(A1:A5) would drop the lowest grade from that range, if you want to sum. Ex.: A1 = 100 A2 = 100 A3 = 100 A4 = 100 A5 = 99 =SUM(A1:A5)-MIN(A1:A5) --> 499 - 99 = 400 Dave
