How to use the COUNT Function in Excel?

COUNT function is used to get the number of entries in a number field that is in a range or array of numbers.

Purpose : Count numbers
Return value : Count of numeric values

=COUNT (value1, [value2], ...)
value1 - An item, cell reference, or range.

value2 - [optional] An item, cell reference, or range.


The COUNT function counts numeric values and ignores text values:

=COUNT(1,2,3) // returns 3
=COUNT(1,"a","b") // returns 1
=COUNT("apple",100,125,150,"orange") // returns 3

Typically, the COUNT function is used on a range. For example, to count numeric values in the range A1:A10:

=COUNT(A1:A100) // count numbers in A1:A10

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

=COUNT(B5:B15) // returns 6