SUMPRODUCT
Returns the sum of the products of corresponding array components.
Math & TrigonometryMath Basics
What it does
Multiplies arrays and sums the results (often used for multi-criteria logic).
Syntax
SUMPRODUCT(array1, [array2], ...)
Arguments
array1(range) — First array.
Examples
Weighted Average
Sum(Qty * Price).
FORMULA
=SUMPRODUCT(A2:A4, B2:B4)
RESULT
60
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Qty | Price |
| 2 | 10 | 2 |
| 3 | 20 | 1 |
| 4 | 5 | 4 |