ROWS (number of rows in a range)

Navigation:  Formulas and functions > Functions from A to Z >

ROWS (number of rows in a range)

Previous pageReturn to chapter overviewNext page

Syntax:

ROWS(Range)

Description:

Returns the number of rows in the specified cell range.

Example:

ROWS(A1:D5) returns 5

See also:

ROW, COLUMNS, AREAS