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.