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 that you want to know the number of rows in.
The following spreadsheets show simple examples of the Excel Rows function. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the 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.