Posted on

MS Excel Sumproduct Function

Spread the love

You have to install MS Office first. Please click the link below:

Suppose you bought 4 products in many quantities. This is time consuming to multiply unit with price and the add them together. Excel has a built in formula for that.

The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products.SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility. Other functions can easily be used inside SUMPRODUCT to extend functionality even further.

Syntax
=SUMPRODUCT (array1, [array2], …)
Arguments
• array1 – The first array or range to multiply, then add.
• array2 – [optional] The second array or range to multiply, then add.

Select array 1 then multiply with selected array2 and press enter.

How to do this calculation manually:
(3*2) +(5*1.50) +(1*60) +(2*10.5) =94.5

Usage notes

The SUMPRODUCT function works with arrays, but it doesn’t require the normal array syntax (Ctrl + Shift + Enter) to enter. The purpose of the SUMPRODUCT function is to multiply, then sum, arrays. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 arrays can be supplied.

For more MS Excel function please click the link:

Leave a Reply