Excel Forum



Excel Magic Trick #196: Grade Book That Subtracts Two Lowest


Use the SUM, SMALL and VLOOKUP functions to create a Grade Book Based on Total Score minus the two lowest score (two lowest score removed) that will calculate grade for you automatically. This is an array formula that uses array syntax to create one formula that adds all the scores and then subtracts the two lowest grades.
VLOOKUP function information.
Formulas for Grades.
Excel Lookup Series
Array Formula





Got a Question? Ask it Here in the Forum.