SUMPRODUCT Function
The SUMPRODUCT function, in the given arrays, multiplies the corresponding items and returns the sum of all the products.
Formula:
=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.
