ROWSReturns the number of rows in a specified array or range.
Sample Usage
ROWS(A9:A62)
ROWS({1;2;3;4;5})
Syntax
ROWS(range)
range – The range whose row count will be returned
See Also
ROW: Returns the row number of a specified cell.
COLUMNS: Returns the number of columns in a specified array or range.
COLUMN: Returns the column number of a specified cell, with `A=1`.
Examples
Returns the number of rows in a reference or array.