Counts how many numbers are in the list of arguments. Text entries are ignored.
COUNT(Number 1 [; Number 2 [; … [; Number 255]]])
Returns an integer value which is the count of numbers among Number 1, Number 2, ..., Number 255.
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.
|=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:
Equivalent Excel functions: