Subtotal(9,offset($a1:$a5,,1,1,row($a$1:$a$5)-1))

[WAYNE_TAI]

Can someone help me understand how this array formula works?

SUBTOTAL(9,OFFSET($A1:$A5,,1,1,ROW($A$1:$A$5)-1))

I have been using this to return the array for cumulative sum, but i'm not sure how Excel evaluates this > I only know it will give me the results I want.

Meaning if I put this formula in one cell, it will return the numbers in Column 2 in a single cell.

1	1
2	3
3	6
1	7
2	9

<tbody>
</tbody>

 

[WAYNE_TAI]

Correction: The formula is incorrect... =SUBTOTAL(9,OFFSET($A$1:$A$5,,,ROW($A$1:$A$5),1))