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 that you want to know the number of rows in.


Rows Function Examples

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.

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

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.


Return to the Excel Lookup and Reference Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net