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
add comment

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.