SUMPRODUCT Function in Excel.

February 8, 2022
1.4K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

SUMPRODUCT Function in Excel.

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.

Given the price and sales volume of each product, to calculate the total sales, are you still using the SUM function to add every value?

That is, in this case, to calculate the sales for each product (25*30 for the first product, 30*30 for the second one) , a beginer may add them together with the SUM function like what is shown in the following picture.

If you know how SUMPRODUCT works, all will be easier!

· Description

The SUMPRODUCT Functioncan multiply ranges together and returns the sum of products.

· 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. 

· Example:

Suppose we want to calculate the total amount of these products.

Open your table in WPS Spreadsheet, click cell B12.

In this case, we need to insert the SUMPRODUCT function.

1) Array1: B2:B8 is the first column that we wish to multiply.

2) Array2: C2:C8 is the second column that we wish to multiply.

The calculation will goes like: B2*C2+B3*C3+...+B8*C8.

So, we choose to enter the following formula in cell B12,

=SUMPRODUCT(B2:B8,C2:C8)

Then we are told that the total sales is 2600.