## How to Use Countif Excel Function to Count Cells that not Blank?

**Step 1 –**Choose the data which have some cells are empty, and some of them contain the values:

**Step 2 –**Enter the formula in the cell, as shown below to calculate the cells which are having some value:

**=COUNTIF(range,” <>” &”)**

- Countif: It means that we are using the Countif, not blank function in excel.
- <>: This symbol is meaning and used in this function to count the number of cells which is equal to nothing or zero.

**Step 3 –**Enter the same formula in the cell to find the numbers by using the Countif, not blank excel formula.:

**Step 4 –**Press enter; you will find the number of cells which are not blank in a particular range.

The result is 26; it means that specific which you have selected is having the 26 rows which are not empty and contains some value which can be number, text, or any value.

4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

### How to use Excel COUNTIF Function to Check if Cell is not Blank and Values are in Text Form?

- If we want to count the range in the cell which is not blank, will use the formula which mentioned in the earlier example:

- Select the range for which you want to check the data which is not blank:

- Click enter; you will get the result of a cell which is not empty:

- You will get the answer with this formula as you get from Countif, not a blank formula if you are using the formula with text data.

### How to use Excel Function to Check if the Cell is not Blank and Values are in Date Form?

- If we want to count the range in the cell which is not blank, will use the excel formula which mentioned in the earlier example:
- Select the range for which you want to check the data which is not blank:

- Click enter; you will get the result of the cell, which is not empty:

- You will get the answer with this formula as you get from Countif, not a blank formula if you are using the formula with data with dates.

### Advantages

- The formula is not upper and lowers case insensitive.
- The user can easily found the number of cells that contain any type of value.
- With the help of excel COUNTIF, not blank function, certain values can be calculated swiftly.
- Countif not blank function is an inbuilt function in excel.
- There is so many count function in excel.
- We can use the same formula to find the same criteria, and only experienced people can understand the difference.
- We need to choose the data format to always be in text type.
- Sometimes excel faces the problem with the long strings while using the Countif, not the blank formula.
- Numerical values cannot be replaced in place of text while counting the number of any text type.

### Things to Remember

- Always use inverted commas while selecting the criteria in a formula to avoid any kind of error in the formula.
- The formula works perfectly with all types of values, whether it is text, number, dates, etc.
- We can use another formula to find the cell, which is not blank; the formula is COUNTA(range).
- For the excel COUNTIF, not blank function, on a basic level, this doesn’t have any kind of effect like to get an error while using the formula. Be that as it may, to stay away from issues in different circumstances, you ought to likewise organize the cells as text.
- You can also customize the COUNTIF, not blank function formula with the greater-than or less-than signs to find the number or value count.
- Value arguments can be only values, the range of values or references to cell ranges in excel worksheet.
- We can enter up to 255 value arguments in a formula if we are using the MS Excel 2007 version or the later version.

### Recommended Articles

This has been a guide to excel COUNTIF, not blank cells. Here we discuss how to use the COUNTIF function to count not blank cells along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

- Not Equal in VBA
- COUNTIF with Multiple Criteria
- VLOOKUP Errors
- Use Not Equal to in Excel
- XML in Excel

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion