Excel Weighted Grade Formula: Calculate Weighted Average Easily
A weighted grade gives more importance to some scores than others — for example, a final exam worth 40% vs. homework worth 10%. Excel's SUMPRODUCT function handles this perfectly.
The SUMPRODUCT Formula for Weighted Grades
=SUMPRODUCT(grades_range, weights_range) / SUM(weights_range)Example: Weighted Course Grade
Say your assignments are:
| Assignment | Score | Weight (%) |
|---|---|---|
| Homework | 85 | 20 |
| Midterm | 78 | 30 |
| Final Exam | 92 | 50 |
Put scores in B2:B4 and weights in C2:C4. The weighted average formula:
=SUMPRODUCT(B2:B4, C2:C4) / SUM(C2:C4) → 86.5Assign Letter Grades with IFS
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", A2>=60,"D", TRUE,"F")When Weights Don't Add Up to 100%
Dividing by SUM(weights) automatically normalizes — so even if weights sum to 80%, the formula still gives the correct weighted average.
FAQ
What is the Excel formula for weighted average grade?
=SUMPRODUCT(scores, weights)/SUM(weights)
How do I calculate GPA in Excel?
Assign numeric GPA points (A=4.0, B=3.0, etc.) and multiply by credit hours, then sum and divide by total credits. See our GPA Calculator tool.
What is the difference between AVERAGE and weighted average?
AVERAGE treats all values equally. Weighted average multiplies each value by its importance before averaging.
Also try our Excel Gradebook Template for Teachers.