Calculation Issues

How to Sum Specific Cells from Two Different Excel Worksheets in WPS Office

Huma Ashraf ChHuma Ashraf Ch Nov 13, 2026 868 views

Question details

The user needs to add selected cells from two worksheets in a 10-sheet workbook without including the worksheets between them.

How to Sum Specific Cells from Two Different Excel Worksheets in WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

Open the workbook in WPS Office, go to the worksheet where the result should appear, and select the target cell.

2
Start the SUM formula

Type =SUM( in the selected cell to begin the formula.

3
Reference the first cell

Click the first worksheet tab, select the cell you want to include, and type a comma. For example, on Sheet 2 select C2.

4
Reference the second cell and finish

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 Different Cells from Two Worksheets Using the SUM Function with Explicit References
Only referenced sheets are included: This formula adds only the explicitly referenced cells and ignores all worksheets between them.
Direct solution

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. 1. Open WPS Spreadsheets: Open your workbook in WPS Spreadsheets by launching WPS Office and selecting Spreadsheets.
  2. 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. 3. Press Enter to calculate: Press Enter to return the total of only the referenced cells.
Adds only the exact cells you reference, skipping intermediate sheetsFull compatibility with Microsoft Excel .xlsx formulas and workbook structureFree, lightweight Office suite with a familiar spreadsheet interfaceSeamlessly opens and saves Microsoft Excel files
microsoft office alternative - wps office

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.