SUMPRODUCT

Multiplies matching items of the ranges and adds the results.

Group: Math

Syntax

SUMPRODUCT(array1, [array2], ...)

Example

← All of Excel Function Reference