# BYCOL

## Content

This function applies a [LAMBDA](/spreadjs/docs/v17/formulareference/FormulaFunctions/other-functions/lambda-function) to each column and returns an array of the results.

## Syntax

`BYCOL(array, lambda(column))`

## Argument

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | An array to be separated by row. |
| *lambda* | A LAMBDA that takes a column and calculates one result.<br>The LAMBDA takes the following parameter:<ul><li>*column*: A column from array</li></ul> |

## Remarks

* If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters".
* If a single value returned from the LAMBDA function is provided instead of the LAMBDA function, it returns a #CALC error.

## Data Types

Returns numerical value.

## Examples

`BYCOL(A1:C2, LAMBDA(array, MAX(array)))`

`BYCOL(A1:C2, LAMBDA(array, SUMSQ(array)))`