# BYROW

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function applies a [LAMBDA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLambda) to each row and returns an array of the results.

## Syntax

BYROW(array, lambda(row))

## Argument

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *array* | An array to be separated by row. |
| *lambda* | A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter: *row*: A row from array |

## Remarks

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

## Data Types

Returns numerical value.

## Examples

`BYROW(A1:C2, LAMBDA(array, MAX(array)))`
`BYROW(A1:C2, LAMBDA(array, SUMSQ(array)))`

## Version Available

This function is available in product version 15 or later.