ROWS

ROWS —

ROWS(reference)

ROWS function returns the number of rows in area or array reference.

If reference is neither an array nor a reference nor a range, ROWS returns #VALUE! error.

ROWS(H7:I13) equals 7.

COLUMN, COLUMNS, ROW.