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: