Documentation/Calc Functions/COUNTA

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(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns an integer value which is the count of non-blank and non-empty entries in arguments or in the cells passed as arguments.

Arguments:
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers.


 * The function counts numbers, dates, error values(Err:502), logical values (like TRUE ) or a text representation of numbers (like "7") passed either as arguments or a reference to the cells or as an array however, empty cells in the reference are not counted.

Additional details:

 * If you want to avoid counting logical values, text, or error values, refer to the COUNT function.
 * For counting number that satisfy a criterion, refer to the COUNTIF function or the COUNTIFS function.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUNT COUNT]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTIF COUNTIF]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTIFS COUNTIFS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTBLANK COUNTBLANK]

ODF standard:
Section 6.13.7, part 2

Equivalent Excel functions:
COUNTA