The SUMPRODUCT function, in the given arrays, multiplies the corresponding items and returns the sum of all the products.


=SUMPRODUCT(array1, array2,...array255)
Whereas "array1, array2,..array255" can be from 2 to 255 arrays whose product has to be found and then added.
Note: The arrays used must be of same dimensions.

Video Tutorial:

Let us find the sum of the products of the array, using the SUMPRODUCT function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question