ROWS

Description Returns the number of rows in a range reference.

Syntax ROWS ( range )

Argument	Description
range	A reference to a range of cells.

Examples This function returns 5:

ROWS(A1:D5)

This function returns 6:

ROWS(C30:F35)

See Also COLUMNS, ROW