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:
Where the array argument is the range for which you want to return the number of rows.
The following spreadsheet shows three simple examples of the Excel Rows function.
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.