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.5

Assign 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.