Statistical
Weighted Average
Calculate a weighted average where different values contribute differently based on their weights. Used for GPA calculation, portfolio returns, weighted survey scores, and more.
Excel Formula
=SUMPRODUCT(A2:A10, B2:B10)/SUM(B2:B10)Step-by-Step Explanation
1
SUMPRODUCT multiplies each value by its weight and sums the results
2
A2:A10 contains the values
3
B2:B10 contains the corresponding weights
4
Dividing by SUM(B2:B10) normalizes by total weight
5
Weights don't need to sum to 1 or 100
Example
| Grade (A) | Credits (B) | |
|---|---|---|
| 3.5 (A-) | 4 | |
| 3.0 (B) | 3 | |
| 4.0 (A) | 3 | |
| 3.7 (A-) | 2 |
Result: =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5) → 3.48 GPA
Common Variations
With percentages
=SUMPRODUCT(A2:A10,B2:B10)When weights are already percentages summing to 100%
Conditional weighted avg
=SUMPRODUCT((C2:C10="Yes")*A2:A10*B2:B10)/SUMPRODUCT((C2:C10="Yes")*B2:B10)Weighted average with condition
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →