ROWS

Description

ROW returns the number of rows in a range reference.

Syntax

ROWS ( range )

Parameter	Description
range	A reference to a range of cells.

Examples

This function returns 5:

ROWS(A1:D5)

This function returns 6:

ROWS(C30:F35)

Also, see