COUNT is a statistics function that counts the numeric values within the specified range. A common use case for this function is counting the cells that have numeric values. In this guide, we’re going to show you how to use the COUNT function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
Syntax
COUNT(value1, [value2], ...)
Arguments
value1 |
An item, cell reference, or range in which the number of cells is to be counted. |
value2 |
Optional. Additional items, cell references, or ranges. You can add additional arguments up to 255. |
Examples
Basic use case
=COUNT(HP,Attack)
Strings, errors, logical values, and dates
=COUNT(MixedTable)
Tip: Use the COUNTA function to include strings, errors, and logical values in the count.
Tips
- The COUNT formula does not count empty cells or cells that contain logical values, text, or error values.
- If you want to count logical values, text, or error values, use the COUNTA function.
- If you want to count only numbers that meet a certain criteria, use the COUNTIF function or the COUNTIFS function.