Applies a LAMBDA function to each column in an array and returns an array of the results.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
BYCOL(array, lambda)The BYCOL function processes an array column by column, passing each column as an array to the specified LAMBDA function. It is particularly useful for performing column-wise calculations, such as finding the maximum or sum of each column in a data range.
=BYCOL(A1:C2, LAMBDA(col, SUM(col)))Результат: Array of 3 sums
Calculates the sum of each of the three columns in the range A1:C2.
BYCOL specifically iterates by columns, whereas MAP can iterate over arrays element by element.