Numbers Formula Not Updating to Include Added Rows
I am trying to transition from the dark side but finding some simple things frustrating. In doing a simple bank account register (previous balance - withdrawal + deposit = new balance), I am able to enter the formula ok and paste it down the column. The problem develops when I add (or delete) a row. The formula does not update and adjust to the new row in the column. I have tried the suggested blank row and add the new row above the blank row but the balance below the new row skips over the added row so I am not getting correct balance. The added row is not picking up the formula and it has to be dragged down. Am I missing something? Or is there no easy way to to do it?
iMac, macOS 10.13