Multiply corresponding items in arrays and sum the results — great for weighted totals and multi-condition sums.
Syntax
SUMPRODUCT(array1, [array2], …)Arguments
array1required
The first range to multiply.
array2…optional
Additional same-size ranges.
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)→$4,820Sums quantity × price across rows (weighted total).
=SUMPRODUCT((A2:A100="East")*(C2:C100))→$42,300Conditional sum without SUMIF.
Align the ranges
All arrays must be the same size and orientation.
Multiply or test
Use commas for plain products, or (cond)*(values) for conditional sums.
SUMPRODUCT handles weighted math and complex boolean logic in one cell; SUMIFS is simpler for straight criteria sums.