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.