# Documentation/Calc Functions/COUNT

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.

• 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

COUNTA

COUNTIF

COUNTIFS

COUNTBLANK

## ODF standard:

Section 6.13.6, part 2

COUNT