SUMPRODUCT

  • Updated

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

Sample Usage

SUMPRODUCT({1,2,3,4},{5,6,7,8})
SUMPRODUCT(B2:B5,C2:C5)

Syntax

SUMPRODUCT(array1, [array2,..])

  • array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.
  • array2, .. - [OPTIONAL] Additional array or range whose entries will be multiplied with corresponding entries in the first such array or range.

Examples

SUMPRODUCT({1,2,3,4},{5,6,7,8}) returns a value of 70.
SUMPRODUCT(B2:B5,C2:C5) returns the sum of the products of corresponding entries in the two arrays..