SUMCUMULATIVE returns the cumulative sum array of a single array of numbers
Excel Formula:
=LAMBDA(array,
LET(a,array,
r,ROWS(a),
c,COLUMNS(a),
vrtcl,r>c,
s,a*IF(vrtcl,(SEQUENCE(,r)>=SEQUENCE(r)),(SEQUENCE(c)>=SEQUENCE(,c))),
return,TRANSPOSE(IF(vrtcl,SUMCOLS(s),SUMROWS(s))),
return)
)| Lambda - Last Cell and Split.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | |||
| 1 | Original Array | |||||||
| 2 | 56 | 65 | 1 | |||||
| 3 | 65 | |||||||
| 4 | 1 | |||||||
| 5 | ||||||||
| 6 | Sum Cummulative | |||||||
| 7 | Vertical | Horizontal | ||||||
| 8 | 56 | 56 | 121 | 122 | ||||
| 9 | 121 | |||||||
| 10 | 122 | |||||||
Sheet1 | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B8:B10 | B8 | =SUMCUMULATIVE(B2:B4) |
| D8:F8 | D8 | =SUMCUMULATIVE(B2:D2) |
| Dynamic array formulas. | ||
Upvote
0
