Use COUNT to count numeric values in Excel.

Examples for numeric values: 1, 2, 3, 1.5, 0, 100234, -1000.

Non-numeric values are usually text values, for example, dog, cat, eleven etc. For non-numeric values, we will use COUNTA function which counts all values in range.

COUNT Example


The syntax of the COUNT function is as follows:

=COUNT(value1, [value2], [value3],…)

value1 is a range. For example, if we want to count the numeric cells in range B2:B5, we will type:


Please note – [value2],[value3] are optional and are not mandatory.

Practice COUNT function Exercise 1

Can you count the numeric values in the following table?

Practice COUNT function Exercise 2

Having an issue with the formulas' language? check out this post