What is SUMPRODUCT?
Multiplies corresponding elements in arrays and returns the sum. Powerful for weighted calculations and multi-criteria analysis without array formulas.
Syntax
=SUMPRODUCT(array1, [array2], ...)
Example
Formula: =SUMPRODUCT(A1:A5, B1:B5)
Result: Total of products
How It Works
Multiplies each A value by its corresponding B value, then sums all products. Perfect for weighted averages, cost calculations, and conditional sums.