How to count cells that contain specific numbers in Excel

How to count cells that contain specific numbers in Excel

In our daily lives, the majority of activities or scenarios we happen to come across will always involve counting in one way or the other. Nearly everything depends on or revolves on counting in this world. We count to obtain the value of things numerically or in terms of numeral values.

The act of tallying a certain quantity to obtain or to reveal the number of items or several objects in a set is what we mostly refer to as counting. Counting is general and done in almost all aspects of life or our daily routines.

Counting cells that contain specific numbers in excel sheets means that the cells have certain numeric values in them. These values may either be different from the others or have one or two numbers that are making unique.

The following are steps we follow so that we do an accurate count of cells with specific numbers. They are discussed in depth below with examples.

 

Step 1

Open the data you wish to work on or if you do not have any recorded data in excel sheets, open the excel sheet, and record some data into it, consider the example below.

The data set in the above excel sheet is comprised of numeric values, as you can see some numbers have a modal frequency of 34 and others a frequency of 22. Those in our case will be the specific numbers.

Step 2

Having the data to use in place in step one, we are now going to get the count of specific numbers in the cells on this step. To do the counting, we will use the COUNTIF function.

This function is used for counting the values if a certain condition is met. Our condition, in this case, is specific numbers which in our case will be 34 or 22.

We will use the COUNTIF function in the formula as follows, =COUNTIF (B2: B6, “*34*”). Write the formula in the formula bar and expect the result in the result cell B7. In the formula above, =COUNTIF is the function and B2 and B6 are the cells while 34 is the specialty number.