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