FUNCTION CATALOGUE / LOGICAL / ARRAY
BYCOL Excel function
Applies a calculation to each column.
Correct sentence to use
Apply [calculation] to each column in [array].
Modify this query in PlainFormula →Example formula
=BYCOL(A2:C10,LAMBDA(c,SUM(c)))
Returns one result per column.
Syntax
BYCOL(array, lambda)
Argument signature: array, lambda
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.