# SUMPRODUCT Function in Excel.

A free Office suite fully compatible with Microsoft Office

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.

Was this helpful?

Yes

No

Trending Tutorials

- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula