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