Documentation/Calc Functions/COUNT

From The Document Foundation Wiki
Jump to: navigation, search

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.

Examples:

Formula Description Returns
=COUNT(2;4;6;"8") The function counts the number of numeric entries and text representation of number for the passed data. 4
=COUNT(2;4;6;"eight") Only number in text format like "8" are considered but not words like "eight". 3
=COUNT(2;4;TRUE) The function counts the number of numeric entries and logical representation of numbers. 3

Related LibreOffice functions:

COUNTA

COUNTIF

COUNTIFS

COUNTBLANK

ODF standard:

Section 6.13.6, part 2

Equivalent Excel functions:

COUNT