How to count cells that contain numbers in Excel?

When working with large amounts of data in Excel, it can be challenging to count the number of cells that contain numbers. This is especially true if the data is not organized in a structured manner. Manually counting the cells that contain numbers can be a time-consuming and error-prone process.

But, Excel provides several functions that can be used to count cells that contain numbers. These functions are easy to use and can save a lot of time and effort.

Problem: Counting Cells That Contain Numbers

Before we dive into the specific functions that can be used to count cells that contain numbers, let’s take a moment to understand why this task can be challenging in the first place. One of the primary issues is that Excel doesn’t always recognize numbers as such, particularly if they are entered as text or if there are formatting issues. This can make it difficult to use the basic count functions, such as COUNT or COUNTA, which don’t differentiate between text and numerical values.

For example, let’s say you have a column of data that includes both numerical values and text, like this:

Column A

If you try to use the COUNT function on this range, the result will be 5, since it simply counts the number of cells that are not blank. However, what we really want is to count the cells that contain numerical values, which in this case is 3.

Functions for Counting Numeric Values

Now that we’ve established the problem, let’s take a look at some of the functions that can be used to count cells that contain numerical values. We’ll start with the most basic functions and work our way up to some of the more advanced options.


The COUNTIF function is one of the most commonly used functions for counting cells that meet specific criteria, including numerical values. The syntax for COUNTIF is as follows:

=COUNTIF(range, criteria)

Where range is the range of cells you want to count, and criteria is the condition that must be met for a cell to be counted. To count cells that contain numbers in our example above, we could use the following formula:


This will count all cells in the range A1:A5 that contain a number greater than or equal to 0. In this case, the result is 3.


The SUMPRODUCT function is another option for counting cells that contain numerical values. It works by multiplying two or more arrays together and then summing the products. To use SUMPRODUCT to count cells that contain numbers, we can use the following formula:


Here, the double negative sign (–) is used to convert the Boolean values returned by the ISNUMBER function (which returns TRUE for cells that contain numbers) into numerical values that can be summed. In our example, the formula would be:


This will also return a result of 3.

That’s all about counting cells that contain numbers in Excel. I hope you got the solution. Thank you.

Photo of author

Bibek Sapkota

I'm Bibek | Tech Enthusiast & Lifelong Learner. | Playing on the Web for the Past Few Years as an SEO Specialist and Full-Time Blogger. I'm constantly seeking out new opportunities to learn and grow, and I love sharing my knowledge with others. This is where I started this blog! Here, you will find me sharing comprehensive reviews, helpful guides, tips-tricks and ways to get the full benefits of evolving technology. On this blog, you can also explore Powerful Knowledge, Tips & Resources On Blogging, SEO and Passive income Opportunities.

Leave a Comment