< Go Back

Count cells that contain numbers

It is easy to count cells that contain numbers in an excel spreadsheet. More so, the function to count cells that contain numbers allows you to have a hold on your numeric data irrespective of how much data you have on your spreadsheet. This function is especially important where you need to get through making numeric calculations fast and on time.



How to Count Cells that Contain Numbers

The above generic formula could be modeled after your spreadsheet to get the cells that have numbers in your own work. The generic formula could also be seen in this way: =COUNT(value1, value2,…value30). To count cells that contain numbers, only one argument is important, follow this: =COUNT(value1, value2,…value30). The argument to calculate cells that contain numbers could be slightly changed to show cells that contain data, alphabets and any other thing. The interesting thing is that you could even count the cells that contain just about anything, like knowing the cells that are blank or without data.

Example 1

In this first example, let’s learn how to count cells that contain just numbers. Carefully follow the example, and you should get it.

Step 1

Ensure you enter the data carefully into the cells. However, on a test spreadsheet, you could enter your number in any cell. To see how very effective the count the cells number is, you could enter spread your numbers across cells as shown below.

Figure 1. Showing all data are correctly entered

Step 2

Numbers in the above table are entered sparsely to prove how well this formula works. This step would show how effecting the =COUNT(rng) formula works. Select any cell you want the result to appear in and punch in the formula.

Figure 2. Function counts cells that contain numbers.

Example 2

In this example, let’s slightly modeled the generic formula to show how we could also calculate the cells that are blank. It is just about the same thing.  We would use the above table to see the number of blanks cells in the spreadsheet. The generic formula is =COUNTBLANK(rng)

Knowing how much blank space is in a spreadsheet could come in handy when you want to be sure you have not jumped cells when computing data in a very busy spreadsheet. A missed cells may mar formula application in simple calculations such as carrying out a simple sum.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment