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     www.energyefficientbuild.com.   May 03, 2013
user Pedro Barbosa (http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/rcZXsKgHcow)
Incremental row sum
Hello,

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?

Cheers!
---------------------------------------------------------------------------------------------------------------
following is a solution to the problem