Syntax #1:
ROWS( )
Returns the number of rows in the worksheet.
Syntax #2:
ROWS( Range or Array )
Returns the number of rows in the array (or range of cells).
Example:
ROWS(A3:D12)
returns 10.
10