SUMPRODUCT
Syntax:
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: