ROWS
TheROWS
formula returns the number of rows in a specified range. It is commonly used to count the number of rows in a dataset or to create dynamic ranges. The ROWS
formula is a part of the Lookup category of functions.
 How to use
ROWS
formula?  Examples of using
ROWS
formula ROWS
formula not working? Similar formulas to
ROWS
Usage
Use the ROWS
formula with the syntax shown below, it has 1 required parameter:
 range (required):
The range for which to count the number of rows.
Examples
Here are a few example use cases that explain how to use theROWS
formula in Google Sheets.
Counting the number of rows in a dataset
By using the ROWS
formula in combination with the RANGE
formula, you can create a dynamic range that adjusts to the number of rows in a dataset. This is useful when working with data that changes frequently, as it ensures that your formulas always include all the relevant data.
Creating a dynamic chart range
When creating charts in Google Sheets, you can use the ROWS
formula to create a dynamic range that adjusts to the number of rows in your dataset. This ensures that your charts always display the correct data, even if the size of your dataset changes over time.
Calculating the total number of cells in a range
By multiplying the number of rows in a range by the number of columns, you can calculate the total number of cells in that range. This can be useful when working with large datasets and trying to get a sense of the total amount of data you are dealing with.
Common Mistakes
ROWS
not working? Here are some common mistakes people make when using the ROWS
Google Sheets Formula:
Incorrect range format
One common mistake when using the ROWS formula is providing an incorrect range format. For example, using a range that includes nonadjacent cells or not specifying the range at all. To correct this mistake, doublecheck the range you are using and ensure that it is in the correct format.
Using nonnumeric arguments
Another common mistake is using nonnumeric arguments in the ROWS formula. This can happen if you accidentally include text or other nonnumeric values in the range. To correct this, ensure that the range you are using only includes numeric data.
Not closing the range properly
If you do not close the range properly in the ROWS formula, you may receive an error message. For example, if you forget to include the closing parenthesis, you will receive an error. To correct this, ensure that you close the range properly.
Using a range with no data
If you use the ROWS formula on a range that has no data, it will return a value of 0. This can be a mistake if you were expecting to see a different value. To correct this, ensure that the range you are using contains data.
Using a range with merged cells
If the range you are using in the ROWS formula contains merged cells, it may return an incorrect value. This is because merged cells can cause issues with the way that Google Sheets counts rows. To correct this, avoid using ranges that include merged cells.
Related Formulas
The following functions are similar to ROWS
or are often used with it in a formula:

COLUMNS
The
COLUMNS
formula returns the number of columns in a given range. This formula is most commonly used to find the number of columns in a table or range of data. 
INDEX
The
INDEX
formula in Google Sheets is used to return a value or reference of a cell at the intersection of a specified row and column in a given range. The formula is commonly used to lookup and retrieve values from a table or range of cells. 
MATCH
The
MATCH
formula is used to search for a specified value within a range and returns the relative position of the value within the range. This formula is commonly used in conjunction with theINDEX
formula to retrieve a value from a specific cell in a range. Thesearch_type
parameter is optional and determines the type of match to be performed, such as exact match, less than, or greater than. 
OFFSET
The
OFFSET
formula in Google Sheets returns a cell or range of cells that is a specified number of rows and columns from a starting cell reference. This formula is most commonly used to create dynamic ranges that can expand or contract as data is added or removed from a sheet. 
VLOOKUP
The
VLOOKUP
function is a lookup formula used to search for a value in the first column of a range of cells (the search key) and return a value in the same row from a specified column in that range. This function is most commonly used to look up and retrieve data from a table.
Learn More
You can learn more about the ROWS
Google Sheets function on Google Support.