title: Why does Excel Table keep including the last added row and how to solve this?
body: <p>I have an Excel table that looks like below:
  <a href="https://i.stack.imgur.com/TR0Uf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TR0Uf.png" alt="enter image description here"></a></p>
  
  <p>The transaction Amount is inputted manually. </p>
  
  <p>The problem is, if I want to add something new in the last row, Excel keeps on including the last row like this:
  <a href="https://i.stack.imgur.com/GwDxn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GwDxn.png" alt="enter image description here"></a>
  See the formula in R4? There's a green arrow in the left side of the cell and it said "Inconsistent calculated formula" and proceeded to include the last row (5), instead of (4) in R4. I have tried unchecking the option for excel autocorrect option and it still doesn't work. </p>
  
  <p>Anybody knows how to solve this problem? Thanks a lot!</p>