This function returns the number of rows in an array.

Syntax

ROWS(array)

Arguments

The argument is an array, an array formula, or a range of cells.

Data Types

Accepts array. Returns numeric data.

Examples

ROWS(B2:B14) gives the result 13

ROWS(R2C6:R4C12) gives the result 3

ROWS($H$2:$H$8) gives the result 7

ROWS(R[2]C[3]:R[8]C[3]) gives the result 7

ROWS(R3C2:R17C2) gives the result 15

Version Available

This function is available in product version 1.0 or later.

See Also

COLUMNS | INDEX | Lookup Functions