Weighted Average Calculator For grades, ratings, portfolios and any values that don't count equally

Enter your values in the first box and their matching weights in the second, one pair per line (or comma-separated). The weighted average counts each value in proportion to its weight.

The two lists must have the same number of entries.

Weighted average
Σ(value × weight) ÷ Σweight
Total weight
Pairs
Simple average

Do this in Excel or Google Sheets

With values in A1:A3 and weights in B1:B3:

ResultFormula
Weighted average=SUMPRODUCT(A1:A3, B1:B3) / SUM(B1:B3)
Simple average=AVERAGE(A1:A3)

SUMPRODUCT is one of Excel's most powerful functions — my Excel course shows you where it shines.

Learn Excel with my course →

When to use a weighted average

A simple average treats every value equally. A weighted average lets some values count more than others — which is what you want when the items aren't equally important. Course grades where each assessment carries a different percentage, a portfolio where holdings differ in size, or product ratings with different numbers of reviews are all classic cases.

How it's calculated

Each value is multiplied by its weight, those products are added together, and the total is divided by the sum of the weights. The weights don't need to add up to 100 — any consistent scale works, because dividing by their total normalises them.

Frequently asked questions

Do the weights have to add up to 100?

No. Weights can be percentages, credit hours, share counts or anything consistent — the calculator divides by their total, so the scale cancels out.

What if my two lists are different lengths?

The calculator will tell you, because every value needs a matching weight. Trim whichever list is longer so they pair up.

Can weights be decimals?

Yes. Values and weights can both be decimals; negative weights are allowed but unusual.