Applies a LAMBDA function to each column in an array and returns an array of the results.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-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.