Home » Excel-Built-In-Functions » Excel-Rows-Function

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

The format of the function is :

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

Examples

The following spreadsheets show simple examples of the Excel ROWS function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Note that the formula in cell A3 returns 1,048,576, as this is the number of rows in Excel 2007. If this example were run in Excel 2003, it would return 65,536.