Google Sheets reference

SUMPRODUCT in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Array Formulasintermediate

=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)

Also in Excel

See the full SUMPRODUCT reference for Excel — including all worked examples, common errors, and FAQ.