The SUMPRODUCT function in Excel is used to multiply corresponding elements in two or more arrays, and then sum the results. It can be used to perform calculations on multiple arrays or to perform weighted averages.
The syntax of the SUMPRODUCT function is:
Syntax
=SUMPRODUCT(array1, [array2], ...)
Note : that when using the SUMPRODUCT function, you must make sure that the arrays are the same size, otherwise you will get a #VALUE! error. Also, if any of the cells in the arrays contain text, logical values, or error values, they will be treated as 0 in the calculation.
Example
