top of page

SUMPRODUCT FUNCTION

The SUMPRODUCT function in Excel calculates the sum of the products obtained from multiplying corresponding elements of two or more arrays.

The syntax of the function is: =SUMPRODUCT(array1, [array2], [array3], …)

Each array can be represented by a column or a row.

bottom of page