# ROWS function

Excel ROWS Function returns the number of rows in a specified range, which can be helpful for various calculations and functions. This function counts the rows within the range and provides a simple numeric output.

ROWS(range)

## How to use

Let’s understand how to use the ROWS function with some examples:

This formula counts the number of rows in the range A1 to A5. If there are values in these cells, it will return 5.

Similarly, this formula counts the number of rows in the range B2 to B8 and returns 7 if there are values in those cells.

If you use this formula on a single cell range, like C1 to C1, it will return 1 since there’s only one row in the specified range.

Remember that ROWS is a simple function, but it can be used in combination with other functions to create more complex formulas and calculations in Excel.

## Examples

Here are a few more examples of how you can use the ROWS function:

If you use this formula on the range A1 to A10 and there are values in all the cells, it will return 10, indicating that there are 10 rows in the specified range.

This formula can count the total number of rows in multiple ranges. If there are 3 rows in each of the three ranges, it will return 9 as the result.