Explanation
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
Syntax
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:
=COUNT(B2:B5)
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?