SUMPRODUCT

Description Multiplies the corresponding cells in the given ranges, then returns the sum of those products.

Syntax SUMPRODUCT (range_list)

Argument Description

range_list Two or more range references that provide the sets of numbers you want to multiply. The values in the upper left cell in each range are multiplied together, then the values in the next cell, etc. All the products are then summed. All the ranges in range_list must contain the same number of cells in the same arrangement. That is, if the first range is three rows deep and three columns wide, the second and subsequent ranges must also be three rows deep and three columns wide.

Argument	Description
range_list	Two or more range references that provide the sets of numbers you want to multiply. The values in the upper left cell in each range are multiplied together, then the values in the next cell, etc. All the products are then summed. All the ranges in range_list must contain the same number of cells in the same arrangement. That is, if the first range is three rows deep and three columns wide, the second and subsequent ranges must also be three rows deep and three columns wide.

Remarks Excel documentation states that SUMPRODUCT takes "2 to 30" arguments. Both Excel and Formula One for Java support 1 to 30 arguments for this function.

Examples The following examples use this worksheet.

This function returns 630:

SUMPRODUCT(A1:C1,A2:C2,A3:C3)

This function returns 50:

SUMPRODUCT(A1:A3,C1:C3)

See Also SUM