I have rows where I need to sometimes cut and paste them into a different part of the sheet. However, there is a sum formula that sums the values in the original part. When I cut the row, the sum formula changes because that row was moved.
Is there a way to prevent the sum formula from changing when I cut the row?
Sum Formula: = SUM($A$1:A$10)
When I cut row A1
and place in below row 12
, the sum formula changes to = SUM($A$2:A$10)