SUMCOLS returns the sum of each column in array (again - like SUMROWS - this was not my creation, but I'm using it in another function so here for reference/use)
Excel Formula:
=LAMBDA(x,MMULT(SEQUENCE(1,ROWS(x),1,0),x))| Lambda - Last Cell and Split.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | |||
| 1 | Original Array | ||||||||||
| 2 | 56 | 29 | 76 | 90 | 5 | 18 | 52 | 3 | |||
| 3 | 65 | 74 | 57 | 41 | 12 | 83 | 15 | 2 | |||
| 4 | 1 | 4 | 43 | 84 | 97 | 86 | 68 | 78 | |||
| 5 | |||||||||||
| 6 | Sum rows | ||||||||||
| 7 | 122 | 107 | 176 | 215 | 114 | 187 | 135 | 83 | |||
Sheet1 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B7:I7 | B7 | =SUMCOLS(B2:I4) |
| Dynamic array formulas. | ||
Upvote
0
