With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, January 2, 2013
yogi_Compute Row By Row Sum Of Successive Rows In Column A Beginning With Row 2
Google Spreadsheet Post #951
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Jan 02, 2013 user Fabio A. said:(http://productforums.google.com/forum/?zx=cb22zc7h6wwc#!category-topic/docs/spreadsheets/7or0v2Kx3ys)
In the first column I have certain values, in the second column, given a certain row, I want it to contain the result of a function applied to all the preceeding rows (plus itself) in the 1st column. In this case the function applied is SUM().
The dumb approach is the one I used: write the formula in the first row, then copy&paste down till the row you want the function to be applied to.
I want it to be automated, though, and function with as many rows in the given column as there are, even if they are removed or added. I thought I'd use ARRAYFORMULA() for this, or MMULT() combined with TRANSPOSE() as I've seen doing in apparently related examples, but after quite a few tries I'm lost.