Function Problems

Add the Results of Two Multiplications in One Excel Formula

Olivia MillerOlivia Miller Nov 18, 2026 869 views

Question details

The user wants to multiply two pairs of cells and add the products in a single cell without helper cells.

Add the Results of Two Multiplications in One Excel Formula
Product
Microsoft Excel
Device & OS
not provided
Scenario
Calculate the sum of two products using one spreadsheet formula.
Observed behavior
The desired result is one cell containing the combined total of both multiplications.
Before you start

Identify the two cell pairs you want to multiply and choose an empty cell for the result. The examples below use B2 with C2 and B3 with C3.

Solution 1Recommended

Use SUMPRODUCT to Multiply and Add Matching Cells

Use SUMPRODUCT when the values are arranged in corresponding ranges.

1
Select the result cell

In Excel, click the empty cell where you want the total to appear.

2
Enter the formula

Type =SUMPRODUCT(B2:B3,C2:C3), replacing the ranges with your own matching ranges if needed.

3
Calculate the result

Press Enter. Excel calculates B2*C2 plus B3*C3 and displays the total in the selected cell.

Use SUMPRODUCT to Multiply and Add Matching Cells
Use matching ranges: The ranges in SUMPRODUCT must have the same dimensions so Excel can multiply corresponding cells.
Calculate in WPS Spreadsheets

Add Two Multiplication Results in WPS Spreadsheets

Use SUMPRODUCT in WPS Spreadsheets to multiply corresponding cells and add the results in one formula.

  1. 1. Open your spreadsheet: Open WPS Office, select Spreadsheets, and open the workbook containing your values.
  2. 2. Choose a result cell: Click an empty cell where you want the combined total.
  3. 3. Enter SUMPRODUCT: Type =SUMPRODUCT(B2:B3,C2:C3), adjusting the ranges to match your data.
  4. 4. Calculate the total: Press Enter to display the sum of the two products.
Calculate multiple products and their sum without helper cellsOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and cell referencesWork with a free, easy-to-use spreadsheet editor
microsoft office alternative - wps office

Frequently Asked Questions

What does =SUMPRODUCT(B2:B3,C2:C3) calculate?

It multiplies B2 by C2 and B3 by C3, then adds the two products in the formula cell.

Can I add two products without using SUMPRODUCT?

Yes. Enter =B2*C2+B3*C3 in the result cell and press Enter.

Can SUMPRODUCT add more than two products?

Yes. Extend both ranges to include additional matching cells, such as =SUMPRODUCT(B2:B5,C2:C5). The ranges must have the same dimensions.

Can I use the same formula in WPS Spreadsheets?

Yes. Select a result cell in WPS Spreadsheets, enter =SUMPRODUCT(B2:B3,C2:C3), and press Enter.