Weighted average
Average where some values count more than others, like grades with credit hours.
The formula
Excel and Google Sheets
=SUMPRODUCT(B2:B10, C2:C10)/SUM(C2:C10)How it works
SUMPRODUCT(B2:B10, C2:C10)Multiplies each value by its weight and adds the results.
/SUM(C2:C10)Divides by the total weight.
Example
| A: Course | B: Grade | C: Credits |
|---|---|---|
| Math | 90 | 4 |
| Art | 70 | 2 |
| History | 80 | 3 |
Tips
- Result for this data: (360 + 140 + 240) / 9 = 82.2.