# Excel BYROW function

## Summary

The Excel BYROW function applies a LAMBDA function to each row in a given array and returns an array of the results. This function is particularly useful for performing row-wise calculations on a range of data, enabling you to analyze or summarize each row individually. BYROW is essential for data analysis tasks where operations need to be applied across rows rather than columns, simplifying the handling of multidimensional data in Excel.
##### Syntax
```				```
=BYROW(array, lambda(row))
```
```
• array: The array or range to be processed by rows.
• lambda: The LAMBDA function that takes a row as its parameter and performs calculations to produce a single result per row.
##### Return value
An array where each element is the result of applying the LAMBDA function to a row in the original array.

## How to use

To use BYROW, specify the array you wish to analyze and the LAMBDA function that will operate on each row. The LAMBDA function must accept a single argument representing a row from the array and should return a single value based on that row.

## Examples

##### Simple BYROW
Calculating the Total for Each Row: To sum the values in each row of a range.
```				```
=BYROW(range, LAMBDA(row, SUM(row)))
```
```
This formula sums the values in each row of the specified range, returning an array of these sums.
##### BYROW for Maximum Values
Identifying the Largest Number in Every Row: To find the maximum value in each row of a range.
```				```
=BYROW(A1:C2, LAMBDA(row, MAX(row)))

```
```
Applies the MAX function to each row within the specified array, returning the maximum value from each row.
##### BYROW for Minimum Values
Finding the Smallest Value in Each Row: To determine the minimum value in each row.
```				```
=BYROW(A1:C2, LAMBDA(row, MIN(row)))

```
```
Utilizes the MIN function within a LAMBDA to identify and return the smallest value from each row in the array.
##### BYROW for Average Values
Calculating the Average for Each Row: To compute the average value of each row in a range.
```				```
=BYROW(A1:C2, LAMBDA(row, AVERAGE(row)))

```
```
This calculates the average of the values in each row, returning an array of average values for the specified range.
##### BYROW for Row-Wise Summation
Calculating the Total for Each Row: To sum the values in each row.
```				```
=BYROW(A1:C2, LAMBDA(row, SUM(row)))

```
```
This example leverages a LAMBDA function within BYROW to sum the values in each row, demonstrating BYROW’s utility for performing row-specific aggregations.