Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate a weighted score in Excel and Google Sheets
Topic:RANK & statistical aggregatesExcel & Google Sheets
=SUMPRODUCT(B2:B6,C2:C6)/SUM(C2:C6)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Criterion | Score | Weight |
| Quality | 85 | 40 |
| Speed | 70 | 30 |
| Cost | 90 | 20 |
| Support | 75 | 10 |
=SUMPRODUCT(B2:B6,C2:C6)/SUM(C2:C6)→80.5
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
Runs server-side · free · no signup
Step by step
- 1Create two columns: Score (B) and Weight (C). Enter each criterion's score and its corresponding weight.
- 2In an empty cell, enter =SUMPRODUCT(B2:B6,C2:C6)/SUM(C2:C6).
- 3SUMPRODUCT multiplies each score by its weight and sums the products; dividing by SUM of weights normalises the result.
- 4If weights already sum to 1, you can omit the /SUM(C2:C6) part.
Tips
- Express weights as percentages that sum to 100 (or decimals that sum to 1) for intuitive setup — the formula works either way because it normalises.
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
Do my weights need to sum to 100?
No. The formula divides by the sum of weights, so any consistent scale works. However, weights summing to 1 or 100 are easiest to reason about.
Can I use this for a graded rubric?
Yes. List each rubric criterion as a row with its score and weight percentage, and the formula returns the overall weighted grade.
More on RANK & statistical aggregates
See all →Reference
RANK.EQ
Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.
How-toHow to rank values
Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.
ReferenceRANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
How-toHow 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.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
How-toHow to calculate a weighted average
Combine values and their weights with SUMPRODUCT divided by the total weight. Works the same in Excel and Google Sheets.