Multiply corresponding items in arrays and sum the results — great for weighted totals and multi-condition sums.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
SUMPRODUCT(array1, [array2], …)SUMPRODUCT multiplies aligned ranges element by element, then adds the products. Beyond weighted averages, it doubles as a powerful conditional counter/summer using boolean arrays, e.g. SUMPRODUCT((region="East")*(amount)).
=SUMPRODUCT(B2:B10, C2:C10)Result: $4,820
Sums quantity × price across rows (weighted total).
=SUMPRODUCT((A2:A100="East")*(C2:C100))Result: $42,300
Conditional sum without SUMIF.
SUMPRODUCT handles weighted math and complex boolean logic in one cell; SUMIFS is simpler for straight criteria sums.