Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.