Documentation/Calc Functions/ROWS

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

ROWS

Category:

Spreadsheet

Summary:

Returns the number of rows in a reference or array.

Syntax:

ROWS(Array)

Returns:

Arguments:

Array is the reference or named area whose total number of rows is to be determined.

Additional details:

Examples:

=ROWS(B5) returns 1 because a cell only contains one row.

=ROWS(A10:B12) returns 3.

=ROWS(Rabbit) returns 3 if "Rabbit" is the named area (C1:D3).

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: