How to calculate a weighted average in Excel and Google Sheets

Topic:RANK & statistical aggregates

Excel & Google Sheets

=SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1B2:B10 are the values; C2:C10 are their weights.
2SUMPRODUCT multiplies each value by its weight and adds the results.
3Divide by SUM of the weights to get the weighted average.

Tips

The values and weights ranges must be the same size.
Use this for grade averages, weighted scores, or price-per-unit blends.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

How is a weighted average different from a normal average?

A normal average treats every value equally. A weighted average lets some values count more, based on the weight you assign each one.

More on RANK & statistical aggregates

RANK.EQ

Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.

How to rank values

Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.

RANK.AVG

Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.

How to calculate standard deviation

Measure how spread out your numbers are with STDEV for a sample or STDEVP for a whole population. Works in Excel and Google Sheets.

PERCENTILE

Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.

How to calculate standard deviation

Use STDEV.S for a sample or STDEV.P for a full population to measure the spread of values around the mean.

Formulas used

SUMPRODUCT SUM AVERAGE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026