I have a spreadsheet that keeps a running balance of a credit card with the newest transactions at the top (just like credit card web sites).
An example of the formula for each cell in the Balance column is
=$F$16+SUM(OFFSET($F13, 0, -1, ROWS(E13:E15)-(ROW()-ROW($F$12)-1)))
Everything works fine except as I insert new rows to add transactions, I have to manually fill the formula up. I'm trying to find a way to apply the formula for all rows in the column. I was able to do this with Numbers. I've looked into =ARRAYFORMULA but I can't get the syntax right.
I'd like to be able to insert new rows and have the balance column automatically populated w/ the formula.