# How to calculate a weighted grade percentage in Excel

Multiply each score by its weight and divide by the total weight: `=SUMPRODUCT(B2:B6,C2:C6)/SUM(B2:B6)`.

**Excel:** `=SUMPRODUCT(B2:B6,C2:C6)/SUM(B2:B6)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E |
| --- | --- | --- | --- | --- |
| Category | Weight | Score |  | Final grade |
| Homework | 0.2 | 0.92 |  |  |
| Quizzes | 0.15 | 0.85 |  |  |
| Midterm | 0.25 | 0.78 |  |  |
| Project | 0.15 | 0.95 |  |  |
| Final exam | 0.25 | 0.81 |  |  |

Formula in F1: `=SUMPRODUCT(B2:B6,C2:C6)/SUM(B2:B6)`

Result: 85.2%

## How it works

SUMPRODUCT multiplies each score by its weight and adds the results: 0.2 × 92% + 0.15 × 85% and so on, 85.15%. Dividing by the sum of the weights makes the formula correct even when the weights don't add up to exactly 100%, for example before the final exam is graded.

## Other ways

- `=SUMPRODUCT(B2:B6,C2:C6)`: Enough when the weights always add up to 100%.
- `=AVERAGE(C2:C6)`: The unweighted average, for comparison. (Returns 86.2%, treating homework and the final exam as equal.)

## Common mistakes

- Weights typed as 20, 15, 25 instead of 20%, 15%, 25% give a grade 100 times too big unless you divide by SUM of the weights, which the main formula does.
- A blank score counts as 0 in SUMPRODUCT. If a category isn't graded yet, see the FAQ.

## Questions

**How do I calculate the grade so far, skipping ungraded categories?**

Divide by the weights of graded categories only: `=SUMPRODUCT(B2:B6,C2:C6)/SUMIF(C2:C6,"<>",B2:B6)`.

**How do I turn the percentage into a letter grade?**

Look it up: `=XLOOKUP(F1,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"},,-1)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/weighted-grade-percentage