How to Use SUMPRODUCT Function

The SUMPRODUCT function adds all the multiplication results for all arrays.

Formula:

=SUMPRODUCT(array1, [array2], [array3], …)

Explanations:

– Array1 is required, the first array to multiply then add.

– Array2 is optional, the second array to multiply then add.

– Array3 is optional, the third array to multiply then add.

Cautions:

– The array arguments must have the same dimensions to multiply then add together.

– SUMPRODUCT Function returns the sum of all numbers when there is only one array.

Example 1: The sum of column A

=SUMPRODUCT(A2:A11)

The sum of the numbers in column A is 55.

Example 2: The sum of the product of column A and column B

=SUMPRODUCT(A2:A11, B2:B11)

The sum of the product of column A and column B is 0.

Download: SUMPRODUCT Function

Leave a Reply