To return the number of rows in a reference.

`ROWS(array)`

- reference - [OPTIONAL] refers to the cell or range of cells for which the row number is being returned

`=ROWS(A1:F10)`

This example returns 10 because there are 10 rows in the range A1:F10

`=ROWS(A1:Z100)`

This example returns 100 because there are 100 rows in the range A1:Z100.

`=ROWS({1;2;3;4;5})`

This example returns 5 because the array constant argument has 5 rows.

The ROWS function is used to count the number of rows in an array, array formula, or cell range reference.

- The ROWS function takes one argument called array, which can be a range or a reference to a single contiguous group of cells.
- To count the number of columns in a range, use the COLUMNS function instead of the ROWS function.
- To get row numbers, use the ROW function instead of the ROWS function.
- To lookup a row number, use the MATCH function instead of the ROWS function.

The ROWS function returns the count of rows in a given reference.

The ROWS function takes one argument, called array, which can be any range or array. Note that the array in this argument can be a constant or can be created by another formula.

To get the total number of cells in a range using ROWS, you need to combine it with COLUMNS. The total number of cells in a range is returned by the COLUMNS function multiplied by ROWS.

Drop CSV