How to Make an Excel gradebook that removes the lowest score

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

1 Comment

Thank you for this informative video!
My courses have multiple weighted categories, and I'd like to drop the lowest percentage in the work category and then show an average for that work category (per student). My Excel grade sheet has a max value (total points for the work category). In that introductory cell, I wrote =SUM(C4:N4)-MIN(C4:N4) so that the lowest percentage is dropped. However, I would like to know how to average the remaining percentages. What formula do I write in the average cells to reflect the dropped percentage as well as the remaining percentages?

Share Your Thoughts

  • Hot
  • Latest