Use Excel SUMPRODUCT to Multiply and Sum Multiple Cell Ranges
Question details
The user wants to replace a long multiplication formula with a concise formula that multiplies corresponding cells across multiple ranges and adds the results.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Calculate the total of products from corresponding cells in rows 7, 9, and 10 across columns D through R.
- Observed behavior
- The desired formula should calculate D7×D9×D10 through R7×R9×R10 and sum those products.
Check that the ranges cover the same number of cells and that their corresponding values are numeric. Identify the cell where you want the total to appear.
Multiply Corresponding Ranges and Sum Them with SUMPRODUCT
Use SUMPRODUCT to replace separate multiplication terms with one formula.
In Excel, click the empty cell where you want the total to appear.
Type =SUMPRODUCT(D7:R7,D9:R9,D10:R10) into the cell or formula bar.
Press Enter. Excel multiplies the corresponding values in the three ranges and adds the products.

Multiply and Sum Ranges in WPS Spreadsheet
Use SUMPRODUCT in WPS Spreadsheet to calculate and total products from corresponding cells in multiple ranges.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
- 2. Choose a result cell: Click the cell where you want to display the total.
- 3. Enter SUMPRODUCT: In the cell or formula bar, type =SUMPRODUCT(D7:R7,D9:R9,D10:R10), adjusting the ranges to match your data.
- 4. Calculate and save: Press Enter to calculate the result, then use File > Save to save the workbook.

Frequently Asked Questions
What does SUMPRODUCT calculate in this example?
The formula =SUMPRODUCT(D7:R7,D9:R9,D10:R10) multiplies the three values in each column, then adds the products from columns D through R.
Do all SUMPRODUCT ranges need to be the same size?
Yes. Select ranges with matching dimensions, such as D7:R7, D9:R9, and D10:R10. Mismatched dimensions can produce a #VALUE! error.
What happens if a cell in a range contains text?
SUMPRODUCT treats nonnumeric entries in its array arguments as zero. Check the source cells if text or numbers stored as text make the total unexpected.
Why does Excel reject the commas in my formula?
Your regional settings may require semicolons as argument separators. Try =SUMPRODUCT(D7:R7;D9:R9;D10:R10) in the formula bar.




