ROWS(array)

The ROW function returns the number of rows in a reference or array.

For example:

ROWS(F5..H10)  returns 6

ROWS({1, 2; 9, 8}) returns 2

If you have created a named range called myarea, that refers to the range A1..D4, then:

ROWS(myarea)   returns 5

See also:

Other lookup functions