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 for which you want to return the number of rows.

## Rows Function Examples

The following spreadsheet shows three 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 (which returns the number of rows in the whole of column B of the spreadsheet) returns the value **1,048,576**, as this is the number of rows in Excel 2010. If this example were run in Excel 2003, it would return the number **65,536**.

Further information on the Excel Rows function is provided on the Microsoft Office website.