WPS Spreadsheets: Add Cells from Another Sheet with a Formula
Question details
Add the values in cells C796 and D796 on Sheet A and return their total in cell C20 on Sheet B.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A workbook contains two worksheets, and the user needs to calculate a total from cells on Sheet A in a destination cell on Sheet B.
- Observed behavior
- The desired total is not yet entered in Sheet B cell C20; the user needs a valid cross-sheet formula.
Confirm that the worksheet is named exactly Sheet A, including the space, and that cells C796 and D796 contain the values to add. Open Sheet B and select cell C20 before entering the formula.
Enter a cross-sheet SUM formula in Sheet B cell C20
Use this recommended method to add the two adjacent cells from Sheet A and place the result in Sheet B.
Because C796 and D796 are adjacent, a range-based SUM formula is concise and easy to maintain. If the worksheet name contains spaces, enclose it in single quotation marks.
Go to Sheet B and click cell C20.
Type =SUM('Sheet A'!C796:D796) in the formula bar or directly into cell C20.
Press Enter. WPS Spreadsheets will calculate the sum of Sheet A cells C796 and D796 and display it in Sheet B cell C20.
Build the cross-sheet formula by selecting cells
Use this method when you want WPS Spreadsheets to insert the worksheet and cell references while you create the formula.
Calculate Cross-Sheet Totals Easily in WPS Spreadsheets
WPS Spreadsheets lets you reference cells across worksheets with familiar formulas such as SUM. Enter the source range from Sheet A, return the result to Sheet B, and continue working with a lightweight spreadsheet interface.
- 1. Open the workbook: Launch WPS Office, choose Spreadsheets, and open the workbook containing Sheet A and Sheet B.
- 2. Select the destination: Click the Sheet B tab and select cell C20.
- 3. Enter a cross-sheet formula: Type =SUM('Sheet A'!C796:D796) in C20, or select the source range after typing =SUM(.
- 4. Confirm the calculation: Press Enter and verify that the total from Sheet A appears in Sheet B cell C20.
Frequently Asked Questions
What formula adds C796 and D796 from Sheet A in WPS Spreadsheets?
In Sheet B cell C20, enter =SUM('Sheet A'!C796:D796). You can also use ='Sheet A'!C796+'Sheet A'!D796.
Why does the worksheet name need single quotation marks?
Sheet A contains a space, so the worksheet reference should be written as 'Sheet A'!C796. Names without spaces can usually be referenced without quotation marks.
Why is my SUM formula showing an error with commas?
Your regional settings may use semicolons as function separators. Replace the comma in =SUM('Sheet A'!C796,'Sheet A'!D796) with a semicolon.
Can I add the existing value in Sheet B C20 to the source cells?
Not with a formula placed in C20 that refers to C20 itself, because that creates a circular reference. Put the calculation in another cell or use a separate process to update C20.
