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], ... )

#1)
Using the SUMPRODUCT function:
#2)
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.
#3)
One thing:
SUMPRODUCT treats array entries that are not numeric as if they were zeros.

Summary

The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products.
comments powered by Disqus