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.


=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:

Excel COUNTA Function. Excel COUNTBLANK Function. Excel COUNTIF Function. Excel COUNTIFS Function.

Count Unique Values in Excel Using COUNTIF Function. Using Multiple Criteria in Excel COUNTIF and COUNTIFS Function How to Count Cells that Contain Text Strings.