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

ROWS(`array`)

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

`=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`.