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 is to multiply and then add.
  • Array2 is optional, the second array is to multiply and then add.
  • Array3 is optional, the third array is to multiply and then add.

Cautions:

  • The array arguments must have the same dimensions to multiply and 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