Weighted Average Calculator

Enter values and weights to get the weighted mean instantly.

100% in your browser — nothing uploaded

Calculate weighted average for grades, portfolios and surveys

Value

Weight

Decimals: use a period or a comma — 99.5 or 99,5.

—Weighted average

—Simple average

—Total weight

—Rows

Common use cases: GPA, portfolio returns, weighted grading, surveys.

Excel / Google Sheets formula

Values are in A2:A10 and weights are in B2:B10.

=SUMPRODUCT(A2:A10, B2:B10) / SUM(B2:B10)

SQL

Weighted average in a single query:

SELECT SUM(value * weight) / NULLIF(SUM(weight), 0)
       AS weighted_avg
FROM   data;

About this weighted average calculator

Enter value–weight pairs and get the weighted average: Σ(value × weight) / Σ(weight). Add as many rows as you need — the calculator updates in real time. You also see each row’s contribution to the total, the percentage of total weight it represents, and a comparison with the simple (unweighted) average.

Weighted averages appear everywhere: GPA calculations (credits × grade points), investment portfolio returns (allocation × return), survey scoring (importance × rating), and any situation where some values matter more than others. The tool includes the Excel SUMPRODUCT formula and a SQL query so you can replicate the result in your own data.

Reference tables

Z-Score Table — Standard Normal DistributionLook up the area to the left of any z-score, positive or negative, to four decimal places.

FAQ

When should I use a weighted average instead of a simple average?

Use a weighted average whenever the items have different importance, frequency, or size. A GPA weights courses by credit hours because a 4-credit A matters more than a 1-credit A. A portfolio return weights assets by allocation because $100k in stocks matters more than $1k in bonds.

What happens if a weight is zero?

A zero weight means that value has no influence on the result — it is effectively excluded. The calculator still shows it in the breakdown but its contribution is zero.

Can I calculate GPA with this?

Yes. Enter your grade points as values (4.0 for A, 3.0 for B, etc.) and the credit hours as weights. The weighted average is your GPA.