Count the number of cells with numeric data in a range in Microsoft Excel

In this chapter, you’ll learn about how to count the number of cells with numeric data in a range in Microsoft Excel. We will use COUNT function.

COUNT function is used for counting the number of cells within a row, column and defined range.

Count the number within column:

Let’s take an example and understand:-

We have data in a column in which we have few blank cells, few cells contain text and few cells are have numbers. So, in this column we want to calculate number cells.

Follow below given steps:-

Enter the formula in cell B2
=COUNT(A2:A13)

Press Enter
The function will return 7

Count the number within Row:

Let’s take an example and understand:-

We have data in row in which we have few blank cells, few cells are containing text and few cells are having numbers. So, in this row we want to calculate numbers cells.

Follow below given steps:-

Enter the formula in cell A3
=COUNT(A2:L2)

Press Enter
The function will return 7

Count the number within Row:

Let’s take an example and understand:-

We have data in the range A1:C10, same problem we have in the data. Few cells contain the numbers, few contain text and few cells are blank.

How we count the number within a range:-

Follow below given steps:-

Enter the formula in cell D2
=COUNT(A2:C10)

Press Enter
The function will return 17, it means 17 cells are containing the numbers within range

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

David
March 20, 2019 at 4:12 am

Im using COUNT successfully but ran into a problem when trying to use dynamic named range with it. For some reason if I just use count it calculates perfectly. If I setup a dynamic named ranged and apply it in the formula it reduces the number of the count. Im Using OFFSET(SHEETNAME!$STARTCELL,0,0,COUNTA(range),1)

Any ideas what Im doing wrong or what I should be doing differently perhaps?

Thanks,
D

Reply ↓
- Exceltip
  August 10, 2019 at 12:17 pm
  
  if you are naming data in column A as "data" starting from A5 using below formula in named range.
  =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),1)
  then
  =count(data) will give you the correct answer.
  
  if it doesn't help, kindly discribe the problem.
  
  Reply ↓