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
