SUMPRODUCT:
Returns the sum of the products of corresponding array components
The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products.
SUMPRODUCT takes
1 required argument and
254 optional arguments:
Syntax: SUMPRODUCT(array1,
[array2], ...
)
Using the SUMPRODUCT function:
The arguments for the SUMPRODUCT function are:
Argument

Required?

Description

array1 
Required 
The first array argument whose components you want to multiply and then add. 
array2, ... 
Optional 
Array arguments 2 to 255 whose components you want to multiply and then add. 
• SUMPRODUCT treats array entries that are not numeric as if they were zeros. 
The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products.