Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score and Weights Assigned to different Categories (Tests and Quizzes) that will calculate grade for you automatically. VLOOKUP function information. Formulas for Grades. Excel Lookup Series
Questions about Excel Magic Trick #197: Grade Book with Weights
Want more info about Excel Magic Trick #197: Grade Book with Weights?
Get free advice from education experts and Noodle community members.