Adding a new row with option-up arrow is messing up my formula
Hi all.
I have a spreadsheet for my personal finances & it has several accounts side by side.
Each one has an IN, OUT & TOTAL column &, in addition to this, the credit cards have a CREDIT LIMIT column that allows me to have an AVAILABLE CREDIT total alongside the current balance.
Some time ago, a very kind soul on here helped me with a fabulous formula that allowed me to add new rows & have the totals update themselves, saving me the trouble of having to go along every column & drag the box down in order to update each column.
The formula looks like this:
Up until recently, it's worked like a charm. I select a cell (usually in the ITEM column that describes what each entry is for) type OPTION - UP ARROW & a new row is created. All the totals across all of the columns containing this formula would automatically update & it's saved me hours.
Suddenly it seems to have stopped working.
When I type OPTION-UP (or DOWN) a new row is added & all of the cells contain the correct cell references. Everything looks normal, except the numbers in the columns don't update any more.
What have I done wrong? :)
What other information might you need, in order to help?
MacBook Pro 15″, macOS 10.15