SUMPRODUCT Formula in MS Excel

SUMPRODUCT Formula in MS Excel

The SUMPRODUCT formula in MS Excel calculates the product of corresponding elements in two or more arrays and then returns the sum of those products.

The syntax of the SUMPRODUCT formula is as follows:

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

Where:

• array1: The first array of numbers to be multiplied and summed.
• [array2], ...: Optional. Additional arrays of numbers to be multiplied and summed.

For example, the following formula would multiply the values in cells A1 and B1, and then return the sum of those products:

=SUMPRODUCT(A1:A3, B1:B3)

The SUMPRODUCT formula is useful for calculating a sum of products for a range of numbers, such as for performing calculations based on weighted averages, or for calculating a running total of products for a range of values.