ROWS

Returns the number of rows in the specified range or array.

Syntax

ROWS( ReferenceOrArray r ) → Integer

Parameters

r

Required. A reference to a range of cells or an array for which to return the number of rows.

Example

Formula

=ROWS(A1:E4)
=ROWS({1;2;3|4;5;6})

See Also

Function Reference
COLUMNS Function