Excel Forum
Similar Content
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This met...
Hide Data Within a Worksheet in Excel
Tutorial: In Excel you can actually hide data that is stored within a worksheet. This allows you to ...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...



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.