About the Weighted Average Calculator
This tool computes a weighted arithmetic mean from two lists you enter: Values and matching Weights. You get four live results: the weighted average, the sum of weights, the sum of value times weight, and the plain (unweighted) average. Results refresh instantly as you type; there is no calculate button. The page runs entirely in your browser, so nothing is uploaded to a server. Students, teachers, analysts and portfolio managers use it to combine scores, credits, counts or allocations. The interface stays minimal so you can check a number quickly without extra options. You can copy the numeric result or share a link that reopens with your inputs. The method used matches standard formulas and spreadsheet practice, for example SUMPRODUCT divided by SUM in Excel.
How to use it
- 1Enter your Values in the first column in the same order as their weights.
- 2Enter the matching Weights in the second column in the same order as values.
- 3Watch the results update instantly: weighted average, sum of weights, and sum of value×weight.
- 4Copy the result or click Share to create a link that reopens with your numbers.
Worked example
Inputs: Values = 80, 90, 70 and Weights = 3, 4, 2. Sum(value×weight) = 240 + 360 + 140 = 740. Sum(weights) = 3 + 4 + 2 = 9. Weighted average = 740 / 9 = 82.222.
The formula
Weighted average = sum(value x weight) / sum(weights)Each value counts in proportion to its weightIf every weight is the same, it equals the plain averageResults update instantly as the visitor types; there is no calculate buttonVisitors can copy the result and share a link that reopens with their numbersSource: Weighted arithmetic mean, WikipediaCalculate an average using SUMPRODUCT, Microsoft Support. Last checked 6 November 2026.
What it is good for
- Live update as you type with no calculate button.
- Runs in your browser; nothing is uploaded.
- Shows weighted average plus sum of weights and sum of value×weight.
- Accepts only numeric Values and matching Weights in the same order.
- If total weight equals zero, the weighted average is undefined.
Questions people ask
What inputs do I need?
You need two lists in the same order: Values and their matching Weights. Each value pairs with one weight. Leave no unmatched entries.
Do the weights need to add to 1 or 100?
No. Weights can be any consistent unit. The tool divides by the sum of weights, so you do not need to rescale them to 1 or 100.
Can I use decimals or negative numbers?
Yes. Values and weights may be decimals. Values can be negative. Negative weights are allowed mathematically but usually are not meaningful in everyday cases.
What happens if the sum of weights is zero?
A total weight of zero causes division by zero, so the weighted average is undefined. Change the weights so their sum is not zero.
How do I reproduce this in Excel?
Use SUMPRODUCT and SUM. Example: =SUMPRODUCT(values_range, weights_range)/SUM(weights_range). This matches the calculator's method.
Where does my data go?
The tool runs in your browser and does not upload your numbers to a server. You can copy results or create a share link that encodes your inputs in the URL.
Help keep every tool free
FreeToolr stays free because people help it grow. Share a tool you like, tell us what to build next, or support us on Ko-fi.