ROWS

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.