tiredofit
Wellknown Member
 Joined
 Apr 11, 2013
 Messages
 1,522
 Office Version

 2019
 Platform

 Windows
Assume I have the values 10 and 20 in cells A1 and A2 and cell A3 contains the formula:
which evaluates to 30, as expected.
If I inserted a row between rows 1 and 2, cell A1 would still show 10, cell A3 now shows 20 and cell A4 shows an adjusted formula:
Now if I deleted row 2, the sum row (now reverts to row 3) will show:
The problem is if I deleted row 2, the sum row now will shift up one row to row 2 and show:
but now if I inserted a row after row 1, the sum row (although will shift to row 2) will still show:
which is incorrect.
Is there a way to correct this?
Thanks
Code:
=Sum(A1:A2)
which evaluates to 30, as expected.
If I inserted a row between rows 1 and 2, cell A1 would still show 10, cell A3 now shows 20 and cell A4 shows an adjusted formula:
Code:
=Sum(A1:A3)
Now if I deleted row 2, the sum row (now reverts to row 3) will show:
Code:
=Sum(A1:A2)
The problem is if I deleted row 2, the sum row now will shift up one row to row 2 and show:
Code:
Sum(A1:A1)
but now if I inserted a row after row 1, the sum row (although will shift to row 2) will still show:
Code:
=Sum(A1:A1)
which is incorrect.
Is there a way to correct this?
Thanks