BYROW and BYCOL functions

The BYROW and BYCOL functions are used to perform a calculation given by a LAMBDA function that uses only one argument for a given row or column. This, in a way, distinguishes them from the function mentioned in the previous post. Both functions work in a similar way. They differ only in whether they retrieve the data needed for the calculation from the row or column.

The syntax of these functions looks like this:

BYROW (<array>,<calculation>)

BYCOL (<array>,<calculation>)

For example, if the table shows an overview of sales by country using the formula:


we calculate the maximum value of sales. If we want to reach the minimum value of sales, we will write the formula:


If, in some cases, the data were in rows, we would write similar formulas. The only difference is that we would then use the BYROW function.