Add the Results of Two Multiplications in One Excel Formula
Question details
The user wants to multiply two pairs of cells and add the products in a single cell without helper cells.

- 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.
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.
Use SUMPRODUCT to Multiply and Add Matching Cells
Use SUMPRODUCT when the values are arranged in corresponding ranges.
In Excel, click the empty cell where you want the total to appear.
Type =SUMPRODUCT(B2:B3,C2:C3), replacing the ranges with your own matching ranges if needed.
Press Enter. Excel calculates B2*C2 plus B3*C3 and displays the total in the selected cell.

Add the Two Products Directly
Use a direct formula when you know the individual cell pairs.
Add Two Multiplication Results in WPS Spreadsheets
Use SUMPRODUCT in WPS Spreadsheets to multiply corresponding cells and add the results in one formula.
- 1. Open your spreadsheet: Open WPS Office, select Spreadsheets, and open the workbook containing your values.
- 2. Choose a result cell: Click an empty cell where you want the combined total.
- 3. Enter SUMPRODUCT: Type =SUMPRODUCT(B2:B3,C2:C3), adjusting the ranges to match your data.
- 4. Calculate the total: Press Enter to display the sum of the two products.

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.




