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: