SUMPRODUCT
Returns the sum of products for a list of arguments
Syntax
SUMPRODUCT(array1, [array_n])
Arguments
| Argument | Description | Required |
|---|---|---|
array1 |
The first array or range to perform multiplication, then add | Required |
array_n |
Additional array or range to multiply, then add | Optional |
Examples
Sum products of two arrays
=SUMPRODUCT(A1:A3, B1:B3)
Result ⇒38
| A | B | |
| 1 | 3 | 4 |
| 2 | 4 | 5 |
| 3 | 2 | 3 |
Calculate total sales
=SUMPRODUCT(A1:A3, B1:B3)
Result ⇒165.75
| A | B | |
| 1 | 10 | 5.50 |
| 2 | 15 | 3.25 |
| 3 | 8 | 7.75 |
Weighted average calculation
=SUMPRODUCT(A1:A3, B1:B3) / SUM(B1:B3)
Result ⇒85.6667
| A | B | |
| 1 | 85 | 3 |
| 2 | 90 | 4 |
| 3 | 78 | 2 |
Related Functions
Other Statistical functions: