Friday, May 3, 2013

yogi_Compute Cumulative Sum of Row By Row Entries In Column A

                                          Google Spreadsheet   Post  #1167
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 03, 2013
user Pedro Barbosa (!category-topic/docs/spreadsheets/rcZXsKgHcow)
Incremental row sum

I'm trying to automate a form that when I submit It, it'll increment the previews value by sum above cell number with the new one created.

Something like: A2: =A2+A1

It works when I auto-fill by dragging the above formula to the cells below, but when I submit new record through form it will discard the formula and let a blank cell instead.

I also tried to use arrayformula "=arrayformula(A2+A1)" but gives me error...

So, how can I do?

following is a solution to the problem