Please help!
Suppose in:
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> =sum(A1:A3)
If I have edit a new row at row 4 and enter 40 in the new Cell A4,
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> 40
Cell A5 --> =sum(A1:A3)
The problem arise such that the sum formula in cell A5 does not include the value in the new row added. or change to =sum(A1:A4)
Any Advise??
Many thanks to those who help
Suppose in:
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> =sum(A1:A3)
If I have edit a new row at row 4 and enter 40 in the new Cell A4,
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> 40
Cell A5 --> =sum(A1:A3)
The problem arise such that the sum formula in cell A5 does not include the value in the new row added. or change to =sum(A1:A4)
Any Advise??
Many thanks to those who help