The Excel ROWS Function

Related Function:
COLUMNS function

Function 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.

1 =ROWS( B1 )
2 =ROWS( B1:E5 )
3 =ROWS( B:B )
1 1
2 5
3 1048576

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.

For further information on the Excel Rows function, see the Microsoft Office website.