top of page


Utilize the COUNT function in Excel to tally numeric values.

Examples of numeric values include 1, 2, 3, 4, 0, 99895, -750, etc.

Non-numeric values typically consist of text values such as man, woman, twenty, etc.

For counting non-numeric values, we will employ the COUNTA function, which counts all values within a given range.

The syntax of the COUNT function is: =COUNT(value1, [value2], [value3],…)

bottom of page