How to Sum Specific Cells from Two Different Excel Worksheets in WPS Office
Question details
The user needs to add selected cells from two worksheets in a 10-sheet workbook without including the worksheets between them.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working in a 10-sheet workbook and wants a formula that adds only chosen cells from two sheets, such as Sheet 2 and Sheet 10, instead of using a worksheet range that includes the sheets between them.
- Observed behavior
- The formula should return the total of only the explicitly referenced cells from the two specified worksheets.
Open the workbook in WPS Office and confirm the exact worksheet names and cell addresses you want to sum. If a sheet name contains spaces or special characters, wrap it in single quotation marks in the formula.
Sum Different Cells from Two Worksheets Using the SUM Function with Explicit References
Use this method when the cells you want to add are in different addresses on two worksheets and you need to exclude every sheet between them.
Avoid using a sheet range such as =SUM('Sheet 2:Sheet 10'!A10) for this task, because WPS Spreadsheets would include all worksheets between Sheet 2 and Sheet 10 in the calculation. Instead, reference each sheet and cell separately inside the SUM function.
Open the workbook in WPS Office, go to the worksheet where the result should appear, and select the target cell.
Type =SUM( in the selected cell to begin the formula.
Click the first worksheet tab, select the cell you want to include, and type a comma. For example, on Sheet 2 select C2.
Click the second worksheet tab, select the cell you want to include, type ) and press Enter. The formula will look like =SUM('Sheet 2'!C2,'Sheet 10'!D12).

Sum the Same Cell Address from Two Worksheets Using Explicit Sheet References
Use this method when both worksheets use the same cell address, such as A10, and you want to add only those two cells.
Sum Specific Cells from Two Worksheets with WPS Spreadsheets
WPS Spreadsheets supports the same SUM function and sheet reference syntax as Excel, so you can add only the referenced cells from two worksheets without summing the sheets between them.
- 1. Open WPS Spreadsheets: Open your workbook in WPS Spreadsheets by launching WPS Office and selecting Spreadsheets.
- 2. Enter the SUM formula: Select the result cell, type =SUM(, click the first sheet tab and cell, type a comma, click the second sheet tab and cell, then type ).
- 3. Press Enter to calculate: Press Enter to return the total of only the referenced cells.

Frequently Asked Questions
How do I sum only two worksheets without including the sheets between them?
Use an explicit SUM formula that lists each sheet and cell individually, such as =SUM('Sheet 2'!C2,'Sheet 10'!D12). Do not use a sheet range like =SUM('Sheet 2:Sheet 10'!A10), because that includes all sheets between them.
How do I reference sheet names that contain spaces or special characters?
Wrap the sheet name in single quotation marks, for example =SUM('January Sales'!C2,'December Sales'!D12).
Can I add more than two worksheets with this method?
Yes. Add more references separated by commas inside the SUM function, such as =SUM('Sheet 2'!C2,'Sheet 5'!D8,'Sheet 10'!D12).
Why does my SUM formula show a #REF! error?
A #REF! error usually means a referenced worksheet or cell does not exist. Check the sheet names, quotation marks, and cell addresses in the formula.




