SUMPRODUCT

Sum the respective products of values in ranges.

Parameter List

Syntax
SUMPRODUCT(range1
[range2]
)
range1

The first range or JSON data whose values will be multiplied with corresponding values in additional ranges. For example: A1:A5.

[optional] range2

The second range or JSON data whose values will be multiplied with corresponding values range1. Must be the same size as range1. For example: B1:B5.

Examples

SUMPRODUCT(A1:A2, B1:B2, C1:C2) returns 63.Example 1