Formula Errors

Fix Incorrect Values in Copied Excel SUM Formulas

Nimra MalikNimra Malik Nov 14, 2026 869 views

Question details

The user needs to find why copied SUM formulas return incorrect totals on a new worksheet.

Fix Incorrect Values in Copied Excel SUM Formulas
Product
Microsoft Excel
Device & OS
not provided
Scenario
Data and formulas were copied to a new worksheet, where a SUM formula should total the destination cells.
Observed behavior
The copied formulas returned unexpected values, and a SUM formula over a destination range returned zero.
Before you start

Identify the source range, the destination range, and the cells that should contain fixed values rather than formulas. Select the incorrect total and check its formula in the formula bar.

Solution 1Recommended

Find Unwanted Formulas and Correct the Copied Range

Use this method when a copied worksheet contains unexpected formulas or SUM references the wrong cells.

1
Show the formulas

Open the destination worksheet and select Formulas > Show Formulas. Compare the copied cells with the source range to find sections that contain formulas where you expected values.

2
Inspect the SUM reference

Select the incorrect total and check the formula bar. Make sure a formula such as =SUM(A2:A30) points to the intended destination cells and does not include an unintended worksheet reference.

3
Replace unwanted formulas

Copy the intended source cells, select the matching destination range, and choose Home > Paste > Paste Special > Values. Do this only for cells that should contain fixed values.

4
Check copied references

Select any remaining copied formulas and review their references in the formula bar. Edit relative references or remove unintended $ signs when the formulas should adjust to their new positions.

5
Verify the total

Select Formulas > Show Formulas again to return to normal view, then check the SUM result against the destination cells.

Find Unwanted Formulas and Correct the Copied Range
Pasting values removes formulas: Paste Special > Values replaces formulas in the destination range with their current results, so those cells will no longer update automatically.
Work with formulas in WPS

Review Copied SUM Formulas in WPS Spreadsheets

Open the workbook in WPS Spreadsheets, inspect formulas in the formula bar, and paste values where copied cells should not contain formulas.

  1. 1. Open the workbook: In WPS Spreadsheets, select Open and choose the Excel workbook.
  2. 2. Inspect copied cells: Select cells in the destination range and check the formula bar for formulas where fixed values were intended.
  3. 3. Paste values: Copy the intended source cells, right-click the destination range, and choose Paste Special > Values.
  4. 4. Check the SUM formula: Select the total cell and edit its formula in the formula bar so it references the intended destination range.
Inspect SUM ranges and copied cell references.Replace unwanted formulas with values using Paste Special.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my copied SUM formula refer to the wrong cells?

Copied formulas can shift relative references, while references with $ signs remain fixed. Select the SUM cell and inspect its references in the formula bar, including any worksheet name.

How can I tell whether a copied cell contains a formula?

Select the cell and look at the formula bar. You can also choose Formulas > Show Formulas to display formulas across the worksheet.

How do I copy results without copying formulas?

Copy the source cells, select the destination, and choose Home > Paste > Paste Special > Values. The pasted results will be fixed values rather than formulas.

Why might SUM return zero after I copy a range?

Check that the SUM formula references the intended cells and that those cells contain the expected numeric values. Select cells in the range and inspect the formula bar for unwanted formulas or values stored as text.