Array Formulasintermediate
Calculate a weighted average with SUMPRODUCT
=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full SUMPRODUCT reference for Excel — including all worked examples, common errors, and FAQ.
SUMPRODUCT Excel reference →