How to Count Cells that Contain Numbers

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

Example: You are working with a data file with the first names in the first column, the the last names in the second column, and the salary is in the three column.

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


The result returns 3, and there are three people 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 to, select the first data range, holding the "Ctrl" key, and then select the other data range.

=Count(C3:C5, C7:C10)

The result returns 7, and there are seven people in all Regions.

Note: The COUNT Function


= 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.

Download Count Function

Leave a Reply