SUMPRODUCT ( argument-list )

Description: Multiplies the corresponding elements in the array arguments in argument-list, and returns the sum of those products. An array element that is not numeric is treated as if it contained 0.

Arguments:

Name	Type	Description
argument-list	array of numbers	The arguments in argument-list designate the numeric values to be multiplied.

Return Type and Value: number – The sum of the products of the corresponding elements in the arguments in argument-list.

However, if the array arguments do not have the same dimensions, #NUM! is returned.

[Example:

SUMPRODUCT({2,3}) results in 5
SUMPRODUCT({2,3},{4,5}) results in 23
SUMPRODUCT({2,3},{4,5},{2,2}) results in 46
SUMPRODUCT({2,3;4,5},{2,2;3,4}) results in 42

end example]