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
.