GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
AGGREGATEROWS: Calculates the aggregated values for all rows in an array. The result is a column of aggregated values.
The second argument acts exactly the same as the first argument (function selector) in the SUBTOTAL function.
The second argument acts exactly the same as the first argument (function selector) in the SUBTOTAL function.
Excel Formula:
=LAMBDA(Array,n,
SUBTOTAL(n,OFFSET(Array,SEQUENCE(ROWS(Array),,0),0,1,COLUMNS(Array)))
)| DXLR's LAMBDA.LET Library_v00.07.xlsb | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 7 | AggregateRows | ||||||||||
| 8 | =LAMBDA(Array,n, SUBTOTAL(n,OFFSET(Array,SEQUENCE(ROWS(Array),,0),0,1,COLUMNS(Array))) ) | ||||||||||
| 9 | |||||||||||
| 10 | AggregateRows | ||||||||||
| 11 | 1 | 1 | 1 | 3 | |||||||
| 12 | 2 | 2 | 2 | 6 | |||||||
| 13 | 3 | 3 | 3 | 9 | |||||||
| 14 | |||||||||||
Sandbox | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F11:F13 | F11 | =AggregateRows(B11:D13,9) |
| Dynamic array formulas. | ||
Last edited:
Upvote
0
