I would like to create a column that contains a running decrementing tally, but is decremented by an amount from a different column on the same spreadsheet. Also, I would like to be able to add rows, without modifying this function. (i.e. such that this function will "Autofill" automatically when I insert new rows)
It seems like the ARRAYFORMULA will do this, but every time I've tried, I get a circular reference error. I have an example spreadsheet below with this error, can anyone correct my formula?
https://docs.google.com/spreadsheet/ccc?key=0AqcS_eDL_8umdEtLQ2s5Y1VYNk1wZUZrb25PajhfTkE&usp=sharing