Función de Google Sheets

BYCOL

Applies a LAMBDA function to each column in an array and returns an array of the results.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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.

Argumentos

arrayobligatorioThe array or range to be processed by column.
lambdaobligatorioA LAMBDA function that takes a single column as an argument and returns a calculated result.

Ejemplos

=BYCOL(A1:C2, LAMBDA(col, SUM(col)))

Resultado: Array of 3 sums

Calculates the sum of each of the three columns in the range A1:C2.

Preguntas frecuentes

How does BYCOL differ from MAP?

BYCOL specifically iterates by columns, whereas MAP can iterate over arrays element by element.

Funciones relacionadas

BYROW LAMBDA MAP REDUCE