119 reputation
4
bio website
location
age
visits member for 1 year, 9 months
seen Oct 22 '13 at 22:27

Dec
19
awarded  Popular Question
Sep
23
awarded  Supporter
Jan
4
awarded  Student
Jan
4
comment How to apply a function to all the rows preceeding the current one in an arrayformula?
Oh, I see you've changed your response, now my comment above looks dumb. The GAS approach could be certanly reused for other other kind of operations (not just the sum, which I restate was just an example), but it wouldn't work for functions that are available only within the spreadsheet (think of slope() and intercept(), which are the ones I actually need). I would have to reimplement those functions in javascript.
Jan
3
revised How to apply a function to all the rows preceeding the current one in an arrayformula?
Typo
Jan
3
comment How to apply a function to all the rows preceeding the current one in an arrayformula?
Thanks for the reply, but that's not quite what I asked for. The fact my data is composed of sequential numbers and the fact I apply a sum to them is just for sake of example, but both the data and the function could be anything. Your approach is specific to the example case I gave, and doesn't even use the first column as a source of data, in fact ROW(A:A) expands to a sequence of increasing numbers which is independent of what A:A contains at all.
Jan
2
awarded  Editor
Jan
2
revised How to apply a function to all the rows preceeding the current one in an arrayformula?
Clarified even more.
Jan
2
asked How to apply a function to all the rows preceeding the current one in an arrayformula?