Returns the sum of the products of corresponding array elements.
SUMPRODUCT(array1; array2; ... array30)
array1 to array30 are up to 30 arrays or ranges of the same size whose corresponding elements are to be multiplied.
SUMPRODUCT returns for the i elements in the arrays.
You can use SUMPRODUCT to calculate the scalar product of two vectors.
SUMPRODUCT evaluates each parameter array1 to array30 as an array formula but does not need to be entered as an array formula. In other words it can be entered with the Enter key, rather than Cntrl-Shift-Enter. See the example below.
If you disagree with its speedy deletion, please explain why on its talk page and add a note to this page. If this page obviously does not meet the criteria for speedy deletion, or you intend to fix it, please remove this notice, but do not remove this notice from articles that you have created yourself.
Justification: justification is not presented (justifications are not mandatory, but helps the administrator to evaluate).