# Documentation/Calc Functions/COUNT

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

## ODF standard:

## Equivalent Excel functions:

COUNT