Returns the number of rows in a reference or array.
Returns a positive whole number ranging from 1 to 1,048,576 which is the count of the rows in the given reference.
Array is the reference to a cell range whose total number of rows is to be found. The argument can also be a single cell.
- If Array is not a reference or a named area then the function returns an error value.
|=ROWS(B5)||Here a cell only contains one row.||1|
|=ROWS(A1:C5)||The reference comprises five rows.||5|
|=ROWS(Rabbit) if "Rabbit" is the named range (C1:D3)||The named area comprises 3 rows.||3|
Related LibreOffice functions:
Equivalent Excel functions: