Documentation/Calc Functions/COUNTA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

COUNTA

Category:

Statistical Analysis

Summary:

Counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.

Syntax:

COUNTA(Value1; Value2; ...; Value30)

Returns:

Arguments:

Value1, Value2, ..., Value30 are 1 to 30 arguments representing the values to be counted.

Additional details:

Examples:

The entries 2, 4, 6 and eight in the Value 1-4 fields are to be counted.

=COUNTA(2;4;6;"eight") = 4. The count of values is therefore 4.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: