A weighted average with SUMPRODUCT

Premium

In F1, work out the weighted average score, where each score counts as many times as its weight. Divide the SUMPRODUCT of scores and weights by the SUM of the weights.

F1
ABCDEFG
1Assignment Score Weight Final grade
2Quiz 80 1
3Project 90 3
4Midterm 70 2
5Final exam 85 4
6
7
8

Premium lesson

Unlock SUMPRODUCT and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:VLOOKUPINDEX and MATCH

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?