How to Use the BYROW Function in Google Sheets

Today, we will learn how to use the BYROW function in Google Sheets. The BYROW function is used with the LAMBDA function, which groups the data by rows, where the LAMBDA function takes an input parameter x, which represents a column of the specified range.

When we pass an array of data from the BYROW function, it then passes each room into the LAMBDA function to calculate a single value for that row. In this tutorial, we will explain in detail how to use the BYROW function in Google Sheets.

Pros of BYROW Function in Google Sheets

Let’s suppose you have a data range containing attendance of different students for different days now you want to extract the data results of some specific students by rows simultaneously then rather than extracting each row’s data individually, here you can use the BYROW function to get the results in a group of rows in jiffy.

In short BYROW function makes minutes of tasks in seconds. So, if you also want to learn such a helpful function then read the following article on how to use the BYROW function in Google Sheets.

Syntax

=BYROW(Array_or_range, lambda)

Array_or_range:

It is the data range on which the user wants to be grouped by row.

Lambda:

Lambda is a helping customs function, that has two arguments. It must have a lambda-named function that is applied on the given range to be grouped by row. Secondly, it uses 1 name argument that is used by the function to solve the query.

Step-by-Step Procedure – How to Use BYROW Function in Google Sheets

The procedure of using the BYROW function in Google Sheets is a little tricky and logical, first, you need to think about which operation you want to perform on the target, then follow the syntax and complete the query.

In the following guide on how to use the BYROW function in Google Sheets, we will use the BYROW function with two different scenarios to get a better understanding so let’s get started.

• Simple usage of the BYROW function in Google Sheets
• Using the BYROW function in Google Sheets with the specified condition

Simple Usage of BYCOL Function in Google Sheets

In this method, we will apply the BYROW function simply on the target and get the result grouped by columns.

Step 1

Here, first, we will select the cell and start the function by just writing BYROW with an equal sign into the cell.

Step 2

After starting the function, we will have to provide the reference or range for which we want to get the results as I have selected in the following example.

Step 3

In the BYROW function, there is a helping function LAMBDA function that we can use to pass a named function for the array. So here we will start the LAMBDA function by writing LAMBDA.

Step 4

In the LAMBDA function, as we know there are two arguments, one is a named variable and the second is a named function, here we have written “R” as a variable to resolve the query.

Step 5

As we need to find the average of all rows, so after writing the variable, we started the AVERAGE function and then specified the argument by writing the variable. Once the query is complete, don’t forget to close all the brackets.

Step 6

Once syntax has been completed, now just press the Enter key, all the results will be in front of you as can be seen below as well. Here, you don’t need to drag the formula over the other cells.

Using the BYROW function in Google Sheets with the specified Condition

In this example, we will apply the BYROW function conditionally to find the value if true. Let’s see, how can you use the BYROW function in Google Sheets with a specified condition.

Step 1

First, we will start the BYROW function in the cell, you can insert the function from the menu bar of Google Sheets, or you can also start the function by just writing its name with an equal sign.

Step 2

As we know, the first argument of the BYROW function is the array range on which we want to apply the function. So here we will give the reference of array range.

Step 3

Secondly, start the LAMBDA function by just writing the LAMBDA after putting a comma sign into the syntax.

Step 4

We are looking for a result of those rows whose average is greater than 500, so here we have started the AVERAGE function first with a named variable then we have written the condition that is “>500” then closed all the brackets.

Our syntax has been completed, press the Enter key and let’s see what we get in the results.

Step 5

Here, if you see the rows that had an average of greater than 500 become true and the rest are false. In this way as well, you can use the BYROW function and determine the significance that you want to find.

How to Use BYROW Function in Google Sheets – FAQs

Q: How to use the filter function with the BYROW function in Google Sheets?

A: The filter function in Google Sheets is used to filter the data range and returns the results that meet specified criteria. Similarly, if you want to filter the data that is grouped by rows then you can use a combo of the FILTER function and BYROW function in Google Sheets. Below are the steps to use the FILTER function in Google Sheets.

Step 1

In the following chart, we have some sales of different products quarterly, here we have to find the item that has an average sale of less than 5, so let’s find it with the help of a combination of using the FILTER function and BYROW function.

Step 2

First, place your cursor into the cell where you want to get the result and start the FILTER function first by just writing its name with an equal sign.

Step 3

Then we will provide the range of data that we are looking for as here I am looking for items so here, we have provided the range of Items into syntax.

Step 4

Now, we will start the BYROW function and shall provide the range of sales data to find the average sales simultaneously.

Step 5

Further, according to the BYROW syntax, we will put the LAMBDA function and then specify the variable to run the query. After that we will run the AVERAGE function as have to find the item that has an average sale of less than 5, so here we have written the condition “<5” as well.

Step 6

Now, as you press the Enter key after completing the syntax by closing the brackets, you will get the result we have gotten in the following picture as “Item 2” has an average sale of less than 5.

In this way, you can use the FILTER function with the BYROW function in Google Sheets.

Q: What are common errors while using the BYROW function in Google Sheets?

A: The most common error that we find while using the BYROW function in Google Sheets is the LAMBDA function name argument. You must use a letter or alphabet as a name argument for the LAMBDA function and ensure that use the same argument in the LAMBDA named function.

Conclusion

Hope you enjoyed the above topic on how to use the BYROW function in Google Sheets, if there was any difficulty while using the BYROW function, hopefully, it will be no more after reading the above guide. For more related topics keep visiting Office Demy.