Related Function:

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

Syntax

=ROWS(array)

Arguments

Argument Description
array The range of cells that you want to know the number of rows in

Examples

  A B C
1 Formula Results Notes
2 =ROWS(B1) 1  
3 =ROWS(B1:E5) 5  
4 =ROWS(C:C) 1048576 Function was calculated in Excel 2010. Therefore, the formula returns the value 1,048,576 (the number of rows in Excel 2010). The same result would be returned in Excel 2007. The function would return the value 65,536 in Excel 2003.