I'm trying to make an array formula which sums up all the rows until this row. For clarification column a will be the input and column b would be the output. I'm looking for a way to do this with an arrayformula.
a1:1 b1:1
a2:2 b2:3
a3:5 b3:8
a4:3 b4:11
I tried to use
=ARRAYFORMULA(SUM(INDIRECT("F1:"&ADDRESS(ROW(),COLUMN(F2:F))))) but this doesn't work.
How about
The sumif is evaluated separately for each value in the criteria part so:
In the first row of the output array you have
giving you just the first row of column A.
In the second row of the output array you have
giving you the sum of the first 2 rows and so on.
Since OP changed the question with a clarification, A different answer is submitted below:
B1: