AGGREGATECOLUMNS

[GeertD]

AGGREGATECOLUMNS: Calculate the aggregated values for all columns in an array. The result is a row of aggregated values.
The second argument acts exactly the same as the first argument (function selector) in the SUBTOTAL function.

=LAMBDA(Array,n,
   SUBTOTAL(n,OFFSET(Array,0,SEQUENCE(,COLUMNS(Array),0),ROWS(Array),1))
)

DXLR's LAMBDA.LET Library_v00.07.xlsb
	A	B	C	D	E	F	G	H	I
7		AggregateColumns
8		=LAMBDA(Array,n, SUBTOTAL(n,OFFSET(Array,0,SEQUENCE(,COLUMNS(Array),0),ROWS(Array),1)) )
9
10
11			1	2	3
12			1	2	3
13			1	2	3
14		AggregateColumns	3	6	9
15
Sandbox

Cell Formulas
Range	Formula
C14:E14	C14	=AggregateColumns(C11:E13,9)
Dynamic array formulas.