Use SUMPRODUCT.
Scores are in B2:B6 and weights in C2:C6. In D2 compute the weighted average as SUMPRODUCT(B2:B6,C2:C6)/SUM(C2:C6).
Ready to try it?
Create a free account and try "Weighted Average" free for 7 days, no card required. Earn 200 XP and track your internship progress.
Already have an account? Sign in