ROWS
Description
Returns the number of rows in the specified range.
Syntax
ROWS(
array
)
- array: The array, or reference to a range of cells, to return the number of rows for.
Notes
- When you use ROWS() using a column argument such as B:B, the result is the last row in the sheet, in any column, that has ever contained a value.