Documentation/Calc Functions/COLUMNS

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

COLUMNS

Category:

Spreadsheet

Summary:

Returns the number of columns in the given reference.

Syntax:

COLUMNS(Array)

Returns:

Arguments:

Array is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell.

Additional details:

Examples:

=COLUMNS(B5) returns 1 because a cell only contains one column.

=COLUMNS(A1:C5) equals 3. The reference comprises three columns.

=COLUMNS(Rabbit) returns 2 if Rabbit is the named range (C1:D3).

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: