How to Sum a Column from Another Sheet in WPS Office Spreadsheets
Question details
Display the total of a column on one sheet in a cell on another sheet using a cross-sheet SUM formula.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has data in a column on Sheet 2 and wants to show the total in a cell on Sheet 1 using a cross-sheet SUM formula.
- Observed behavior
- The destination cell on Sheet 1 should calculate and display the total of the referenced range from Sheet 2.
Make sure you know the exact sheet name and cell range you want to total. If the sheet name contains spaces or special characters, wrap it in single quotation marks in the formula.
Use a Cross-Sheet SUM Formula to Total a Column from Another Sheet in WPS Spreadsheets
Use this method when you want a cell on one sheet to show the total of a range located on a different sheet in the same workbook.
The SUM function works across worksheets by adding the sheet name and an exclamation point before the range. WPS Office Spreadsheets follows the same syntax as Microsoft Excel, so existing formulas continue to work.
Open your workbook in WPS Office Spreadsheets, click the Sheet 1 tab, and select the cell where the total should appear.
Type =SUM(Sheet2!A1:A10) directly in the cell or the formula bar, replacing Sheet2 and A1:A10 with your actual sheet name and column range.
Press Enter to calculate the formula. The destination cell now displays the total of the specified column range from the other sheet.
Use WPS Spreadsheets to Sum Data Across Worksheets
WPS Office Spreadsheets supports the same cross-sheet SUM formulas as Microsoft Excel, so you can reference Sheet2 ranges from Sheet1 without converting or rebuilding your workbook.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the workbook that contains Sheet 1 and Sheet 2.
- 2. Select the cell for the total: Click the Sheet 1 tab and select the destination cell where you want the cross-sheet total.
- 3. Enter the cross-sheet SUM formula: Type =SUM(Sheet2!A1:A10) in the formula bar, adjusting the sheet name and range as needed.
- 4. Press Enter and verify the result: Press Enter to calculate the total and confirm it matches the source range on Sheet 2.
Frequently Asked Questions
How do I sum a column from another sheet if the sheet name has spaces?
In WPS Office Spreadsheets, enclose the sheet name in single quotation marks, for example =SUM('Sales Data'!A1:A10).
Can I sum a column from a different workbook?
Yes. Include the workbook name in square brackets, such as =SUM([Book2.xlsx]Sheet2!A1:A10), and keep the source workbook open or update links when prompted.
Does WPS Spreadsheets support Excel cross-sheet formulas?
Yes. WPS Office Spreadsheets uses the same worksheet and range syntax as Microsoft Excel, so formulas like =SUM(Sheet2!A1:A10) work directly.
Why is my cross-sheet SUM formula showing #REF! or #NAME?
Check the sheet name, range, and quotation marks. If the sheet was renamed or deleted, the reference becomes invalid; update the sheet name in the formula to fix it.
