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.
- All Excel versions
COUNT(value1, [value2], ...)
An item, cell reference, or range in which the number of cells is to be counted.
Optional. Additional items, cell references, or ranges. You can add additional arguments up to 255.
Basic use case
Strings, errors, logical values, and dates
Tip: Use the COUNTA function to include strings, errors, and logical values in the count.
- 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.