How to Count Cells that Contain Numbers

To count the number of cells with numbers, you can use the COUNT function, which you can get the counts of number entries in a range or array.


= Count(value 1, value 2…)


– Value 1 is required, which can be the adjacent numbers in a row, a column, or a data range;

– Value 2 is optional.


The COUNT function counts the data range with numbers.

Example 1: To count how many persons in South Region with salary (Adjacent Data)

=Count(C3:C5) There are 3 persons in South Region.

Example 2: To count how many persons in all Regions with salary (Data are not Adjacent)

To count the number of cells that data are not adjacent, select the first data range, holding "Ctrl" key, and then select other data range.

=Count(C3:C5, C7:C10) There are 7 persons in all Regions.

Download Count Function

Leave a Reply