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?
When I cut row
A1 and place in below row
12, the sum formula changes to