ROWS function

ROWS returns the number of rows in a reference or array.

Syntax

ROWS(array)

array is the reference or named area whose total number of rows is to be determined.

Example

=Rows(B5) returns 1 because a cell contains only one row.

=ROWS(A10:B12) returns 3.

=ROWS(Rabbit) returns 2 if the area (C1:D3) is named Rabbit.