Documentation/Calc Functions/ROWS

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

ROWS

Category:

Spreadsheet

Summary:

Returns the number of rows in a reference or array.

Syntax:

ROWS(Array)

Returns:

Returns a positive whole number ranging from 1 to 1,048,576 which is the count of the rows in the given reference.

Arguments:

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.

Additional details:

None

Examples:

Formula Description Returns
=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:

COLUMNS

SHEETS

ODF standard:

Section 6.13.30, part 2

Equivalent Excel functions:

ROWS