Skip to main content

SUMPRODUCT

Definition

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

Sample Usage

Syntax

SUMPRODUCT(array1, [array2, ...])

  • array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.

  • array2, ... [ OPTIONAL - {1,1,1,...} with same length as array1 by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.

Notes

  • Matrix multiplication, MMULT, can also be accomplished using a combination of TRANSPOSE and SUMPRODUCTfunctions.

See Also

TRANSPOSE: Transposes the rows and columns of an array or range of cells.

MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.

 

In order to use the SUMPRODUCT formula, start with your edited Excellentable:

 

 

 

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.