Home » Excel-Built-In-Functions » Excel-Lookup-And-Reference-Functions » Excel-Rows-Function

# The Excel ROWS Function

Related Function:

COLUMNS function## Basic Description

The Excel Rows function takes an Excel range and returns the number of rows that are contained within the range.

The syntax of the function is:

ROWS( array )

Where the array argument is the range that you want to know the number of rows in.

## Rows Function Examples

The following spreadsheets show simple examples of the Excel Rows function.

Formulas: | A |
---|
1 | =ROWS( B1 ) |
---|
2 | =ROWS( B1:E5 ) |
---|
3 | =ROWS( B:B ) |
---|
| Results: |

Note that the above functions were calculated in Excel 2010. Therefore, the formula in cell A3 of the above spreadsheet returns the value **1,048,576**, as this is the number of rows in Excel 2010. The same result would be returned in Excel 2007, but if this example were run in Excel 2003, it would return the number **65,536**.

Further information on the Excel Rows function can be found on the Microsoft Office website.