Returns the number of rows in a specified array or range.
ROWS for BigQuery
Returns the number of rows in a data column.
Sample Usage
ROWS(table_name!fruits)
Syntax
ROWS(column)
column
- The data column whose row count will be returned.
Tip: Null values are counted as well.
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.