ROWS

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.