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 me...
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 ...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.