Fix an Excel SUM Formula That Does Not Update After Cut and Paste
Question details
The user needs an Excel SUM formula to reference cells after they are cut and pasted into another column.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Moving cells used by a SUM formula to another column with cut and paste.
- Observed behavior
- The SUM formula remains linked to the original range rather than updating to the moved cells.
Identify the exact source range, destination range, and SUM formula. Check whether you are moving the entire referenced range or only part of it, because the resulting references may differ.
Test Cut and Paste in a New Excel Workbook
Use a simple test to determine whether the behavior is specific to the workbook or operation.
Open a blank workbook, enter numbers in A1:A3, and enter =SUM(A1:A3) in C1.
Select A1:A3, choose Home > Cut, select B1, and choose Home > Paste. Use Cut rather than Copy.
Select C1 and check the formula bar. For this complete-range move, the formula should read =SUM(B1:B3).
Repeat the test in the original workbook or in Excel for the web. If only the original workbook behaves differently, record the exact range and paste operation for further diagnosis.

Correct the SUM Range and Check Excel Settings
Use this if the formula still points to the wrong cells or the behavior persists in a new workbook.
Work With SUM Formulas in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with formulas while moving between office suites.

Frequently Asked Questions
Should a SUM formula update when I cut and paste its cells?
When you move an entire referenced range with Home > Cut and Home > Paste, Excel normally updates the formula to reference the new location. Moving only part of a range can produce a different result.
Do dollar signs stop references from updating when cells are moved?
No. Dollar signs control how references adjust when a formula is copied; they do not by themselves prevent references from updating when referenced cells are cut and moved.
Why is my SUM result not changing even after I fix the range?
Check Formulas > Calculation Options and select Automatic. In manual calculation mode, Excel may not recalculate the result until you request a calculation.
How can I tell whether an add-in is causing the problem?
In Excel for Windows, open File > Options > Add-ins, choose an add-in type under Manage, and click Go. Temporarily disable the add-ins and repeat the cut-and-paste test.




