Excel COUNT Function

The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references, or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored.

Example #1 - range

In the example shown, COUNT is set up to count numbers in the range B5:B11:

=COUNT(B5:B11) // returns 4

COUNT returns 4, since there are 4 numeric values in the range B5:B11. Text values and blank cells are ignored.

Example #2 - constants

The example below shows COUNT with 3 hardcoded values. Two of the values are numbers, one is text, so COUNT returns 2:

=COUNT(1,2,"apple") // returns 2

Functions for counting

• To count numbers only, use the COUNT function.
• To count numbers and text, use the COUNTA function.
• To count based one one criteria, use the COUNTIF function
• To count based one multiple criteria, use the COUNTIFS function.
• To count empty cells, use the COUNTBLANK function.

Notes

• COUNT can handle up to 255 arguments.
• COUNT ignores the logical values TRUE and FALSE.
• COUNT ignores text values and empty cells.