If you are looking for some of the easiest ways to count if a cell contains number in Excel then you will find this article worthy of it. Sometimes different texts and numbers and other types of variables get mixed up in a column. If you want to count cells based on numbers then let’s go through this article.

**Table of Contents**hide

## Download Workbook

## 7 Ways to Count If Cell Contains Number

I have used the following table wherein the **Size** **column** I have both text and number variables. Here, I would like to count the number of cells here based on the numbers in this column. You will get to know the ways by using the following example.

__Method-1__: Using COUNT Function to Count Cells with Number

You will be able to count cells containing numbers by using **the COUNT function**. In this case, I will use the **Size column** to count the number of cells containing numbers. Here, I have added the **Count column** for this purpose.

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=COUNT(C5:C13)`

Here, **C5:C13 **is the range of values

The **COUNT function** will count the number of cells containing numbers.

** Step-02**:

➤Press

**ENTER**

Afterward, you will get the number of cells containing numbers in the

**Size column**.

__Method-2__: Using COUNTIF Function to Count Cells with Number

You will be able to count cells containing numbers by using **the COUNTIF function**. Here, I will use the **Size column **to count the number of cells containing numbers.

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=COUNTIF(C5:C13,"<>*")`

Here, **C5:C13 **is the range of values

and before the **wildcard, <>** is used which means **Not Equal to** any texts.

** Step-02**:

➤Press

**ENTER**

After that, you will get the number of cells containing numbers in the

**Size column**.

__Method-3__: Counting Cells with Number and Text

Suppose, now you want to count the total number of cells containing both numbers and texts in the **Size column**. To do this you have to use **the COUNTA function**.

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=COUNTA(C5:C13)`

Here, **C5:C13 **is the range of values

The **COUNTA function** will count the number of cells containing numbers and texts.

** Step-02**:

➤Press

**ENTER**

In this way, you will get the number of cells containing numbers and texts in the

**Size column**.

__Method-4__: Counting Cells with Numbers in a Filtered Table

Suppose you want to count numbers in a filtered data table but in this case, you will get the total numbers not only the shown values in the filtered column. But you can count the visible values only after filtering by following this method.

You have to use **the SUBTOTAL function **before filtering the data table.

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=SUBTOTAL(102,C5:C13)`

Here, **102 **is used for using **the COUNT function**

**C5:C13**is the range of values

** Step-02**:

➤Press

**ENTER**

Then you will get the number of cells containing numbers before filtering in the

**Size column**.

** Step-03**:

➤Filter the data table according to your needs

Then you will get the number of cells containing numbers in the

**Size column**which is not hidden.

__Method-5__: Counting Cells with Single Criteria

Assume now you want to count the number of cells in the** Price column** containing numbers.

Here, you will count the cells based on criteria that the *Price* should be only for **Shoe** as a *Product.*

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=COUNTIF(B5:B13,"*Shoe*")`

Here, **B5:B13 **is the range of values

The** shoe **is the criteria, between the **Wildcards **the criteria name has been written for matching partially of the text **Shoe**

** Step-02**:

➤Press

**ENTER**

In this way, you will get the number of cells containing numbers based on criteria in the

**Price column**.

__Method-6__: Using COUNTIFS Function to Count Cells with Multiple Criteria

Suppose, now you want to count cells containing numbers in the **Price column** based on two criteria. The first criteria here is the same as in **Method-5 **and the second criteria is **Price** should be greater than **$1,500.00**. You can do this by using **the COUNTIFS function.**

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=COUNTIFS(B5:B13,"*Shoe*",D5:D13,">1500")`

Here, **B5:B13 **is the first criteria range**Shoe **is the first criteria**D5:D13 **is the second criteria range**“>1500” **is the second criteria.

** Step-02**:

➤Press

**ENTER**

Afterward, you will get the number of cells containing numbers based on multiple criteria in the

**Price column**.

__Method-7__: Using SUMPRODUCT Function to Count Cells with Number

You will be able to count cells containing numbers by using **the SUMPRODUCT function**. In this case, I will use the **Size column** to count the number of cells containing numbers.

** Step-01**:

➤Select the output cell in the

**Count column**

➤Type the following formula

`=SUMPRODUCT((--ISNUMBER(C5:C13)))`

Here, **C5:C13** is the **range**,**T****he ISNUMBER function **will check out if there are numbers and then will return **TRUE** and if there is no number then it will return **FALSE**. Then **—** will convert **TRUE** into **1** and **FALSE** into **0**.

Then **the SUMPRODUCT function** will sum up the values.

** Step-02**:

➤Press

**ENTER**

Then you will get the number of cells containing numbers in the

**Size column**.

## Practice Section

For doing practice by yourself we have provided a** Practice** section like below for each method in each sheet on the right side. Please do it by yourself.

## Conclusion

In this article, I tried to cover the easiest ways to count if a cell contains a number in Excel effectively. Hope you will find it useful. If you have any suggestions or questions feel free to share them with us.