Excel COUNT Function
Summary
The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.
Purpose
Count numbers
Return value
A number representing a count of numbers.
Syntax
=COUNT (value1, [value2], ...)
Arguments
- value1 - An item, cell reference, or range.
- value2 - [optional] An item, cell reference, or range.
Usage notes
The COUNT function counts the number of numbers in supplied values. Values can be items, cell references, or ranges. For example, =COUNT(1, 2, "apple") returns 2. And COUNT(A1:A10) will count the number of numeric values in the range A1:A10.
- Count can handle up to 255 additional values.
- Use COUNTA to include text and logical values. Use COUNTIF to count based on criteria.
- Error values or text values that cannot be coerced into numbers are not counted
- The logical values TRUE and FALSE are not counted.
- Empty cells and text are not counted.