Documentation/Calc Functions/COUNT

Function name:
COUNT

Category:
Statistical Analysis

Summary:
Counts how many numbers are in the list of arguments. Text entries are ignored.

Syntax:
COUNT(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns an integer value which is the count of numbers among Number 1, Number 2, ..., Number 255.

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


 * The function counts numbers, dates, logical values (like TRUE, FALSE) or a text representation of numbers (like "7") passed as arguments. However if an array or a reference to cells then only the numbers in that array or reference are considered ignoring empty cells, logical values, text or error values.
 * The function doesn't count error values passed as arguments.

Additional details:

 * For using logical values, text, or error values, refer to the COUNTA 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/COUNTA COUNTA]

[[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.6, part 2

Equivalent Excel functions:
COUNT