Excel COUNT Function (Example + Video)
When to use Excel COUNT Function
COUNT function can be used to count the number of cells that contain numbers.
What it Returns
It returns a number that represents the number of cells that contain numbers.
Syntax
=COUNT(value1, [value2], …)
Input Arguments
- value1 – the first item, cell reference, or range within which you want to count numbers.
- [value2], … – (optional) up to 255 additional items, cell references, or ranges within which you want to count numbers.
Additional Notes
- Numerical values are counted.
- Dates and text representation of numbers (such as 1 in double quotes – “1”) are counted.
- Logical Values (TRUE/FALSE) typed directly into the formula are counted.
- However, cell reference that refers to cells that contain logical values are ignored
- Arguments that are error values or text that cannot be translated into numbers are not counted.
- If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are not counted.
Excel COUNT Function – Live Example
Excel COUNT Function – Video Tutorial
Related Excel Functions:
