While working in Excel for business purposes or any other purpose there may remain some** blank cells.** Sometimes we need to determine and count them. There are many methods to do it. In this article, you will learn some quick and easy methods to determine and count if a cell is not blank.

**Download Practice Book**

You can download the free Excel template from here and practice on your own.

**4 Easy Ways to Determine If a Cell is Not Blank**

Let’s get introduced to our dataset first. I have placed some ordered book names of an online shop and their delivery dates within 2 columns and 7 rows. Take a look that some books are not delivered yet that’s why the dates are empty. Now we’ll determine the non-blank cells with 4 easy ways.

**Method 1: Use IF Function to Determine a Non-blank Cells**

To show the status I have added a new column at the right side of my dataset. In our very first method, we’ll determine a non-blank cell using **the IF function**. It is used to** return one value** if a condition is true and another value if it’s false. Here, it will show ‘Done’ if it **finds a non-blank cell** and will show ‘Pending’ if it gets a blank cell.

**Step 1:**

⏩ Activate **Cell D5**

⏩ Type the formula given below-

`=IF(C5<>"","Done","Pending")`

⏩ Then just hit the **Enter **button to get the output.

**Step 2:**

⏩ Now **double-click **the **Fill Handle** icon to copy the formula for the rest of the cells.

Soon after you will see the output like the image below-

**Read More:** **If Cell is Blank Then Show 0 in Excel (4 Ways)**

**Method 2: Apply ISBLANK Function to Check If a Cell is Not Blank**

**The ISBLANK function** is used to return **TRUE **when a cell is empty, and **FALSE **when a cell is not empty. That is our task basically so we’ll use it here for our operation. It’s quite easy.

**Steps:**

⏩ Type the formula in **Cell D5**–

`=ISBLANK(C5)`

⏩ Press the **Enter **button then.

⏩ Finally, use the **Fill Handle** tool to copy the formula.

Now take a look at the output-

**Read More:** **How to Calculate in Excel If Cells are Not Blank: 7 Exemplary Formulas**

**Method 3: Insert IF And ISBLANK Functions to Define If a Cell is Not Blank**

We can do the same task in a better way by combining the **IF **and **ISBLANK **functions. The combination will show Pending for a blank cell and Done for a non-blank cell.

**Steps:**

⏩ Write the given formula in **Cell D5** and click the **Enter **button-

`=IF(ISBLANK(C5),"Pending","Done")`

⏩ Then use the **Fill Handle** tool to copy the formula.

Now you will see that all the non-blank cells are determined.

⏬** Formula Breakdown:**

**➥**** ISBLANK(C5)**

The **ISBLANK **function will check **Cell C5** if it is empty or not. For blank cell, it will return **TRUE **and for the non-blank cell, it will return **FALSE**–

**FALSE**

**➥**** IF(ISBLANK(C5),”Pending”,”Done”)**

Then the **IF **function will show Done for **FALSE **and Pending for **TRUE**. So it will return as-

**“Done”**

**Method 4: Combine IF, NOT, And ISBLANK Functions to Detect If a Cell is Not Blank**

Let’s use another combination of functions to determine if a cell is not blank. Which are the **IF**, **NOT****, **and **ISBLANK **functions. It will also show the output like the previous method. The NOT function returns the opposite of a given logical or Boolean value.

**Steps:**

⏩ In **Cell D5 **write the given formula-

`=IF(NOT(ISBLANK(C5)),"Done","Pending")`

⏩ Later, just press the **Enter **button and use the **Fill Handle** tool to copy the formula.

Then you will get the output like this-

⏬ **Formula Breakdown:**

**➥**** ISBLANK(C5)**

The **ISBLANK **function will check **Cell C5** if it is empty or not. For blank cell, it will return **TRUE **and for the non-blank cell, it will return **FALSE**–

**FALSE**

**➥**** NOT(ISBLANK(C5))**

Then the **NOT **function will return the opposite value of the output of the **ISBLANK **function. So it will return as-

**TRUE**

**➥**** IF(NOT(ISBLANK(C5)),”Done”,”Pending”)**

Finally, the **IF **function will show Done for **TRUE **and Pending for **FALSE**. That will return as-

**“Done”**

**3 Quick Ways to Count the Non-Blank Cell Number**

In our previous methods, we learned to determine if a cell is blank or not blank. Now we’ll learn how to count all the non-blank cells within a data range with 3 quick methods.

**Method 1: Use COUNTA Function to Count the Non-Blank Cell Number**

Let’s start with **the COUNTA function**. **COUNTA **function is used to count the non-empty cells. We’ll use it to count the non-blank cells of **Column C.**

**Steps:**

⏩ Activate **Cell D14**.

⏩ Write the given formula in it-

`=COUNTA(C5:C12)`

⏩ Later, hit the **Enter **button for the output.

**Method 2: Apply COUNTIF Function to Sum the Non-Blank Cell Number**

**The COUNTIF function** is used to count the number of cells that meet a criterion. We’ll count the non-blank cells of **Column C** using it.

**Steps:**

⏩ Type the given formula in **Cell D14**–

`=COUNTIF(C5:C12,"<>")`

⏩ Finally, hit the **Enter **button for the output.

**Method 3: Insert COUNTIFS Function ****to Calculate the Non-Blank Cell Number**

We can use **the COUNTIFS function** to count the non-blank cells too. The **COUNTIFS **function is used to count the number of cells in a range for multiple criteria.

**Steps:**

⏩ In **Cell D14** type the given formula-

`=COUNTIFS(C5:C12,">100",C5:C12,"<>")`

⏩ Finally, just hit the **Enter **button for the output.

**Apply Excel Formula for a Cell Which is Not Blank**

If we use an empty cell reference in a formula then it will show an error or incorrect result. So to avoid this we’ll use a different formula that will skip the empty cells and calculate only for** filled cells** using the **IF **and **OR **functions. The **OR **function will determine if any of the conditions in a test is **TRUE. **For that, I have made a new dataset that represents two years’ sales for three consecutive months. Now I’ll find the differences for every same month of two years. Look that one cell is empty in our dataset. Our formula will be able to skip it.

**Step 1:**

⏩ Type the formula given below in **Cell C7**–

`=IF(OR(C5="",C6=""),"",C5-C6)`

⏩ Hit the **Enter **button for the result.

**Step 2:**

⏩ Then use the **Fill Handle** tool to copy the formula for the other columns.

Soon after you will see that our formula is not applied for the empty cell.

⏬** Formula Breakdown:**

**➥**** OR(C5=””,C6=””)**

At first, the **OR **function will check if any of the cells(**C5, C6**) are empty or not. It will return as-

**FALSE**

**➥**** IF(OR(C5=””,C6=””),””,C5-C6)**

Then the **IF **function will show nothing for **TRUE **and will subtract for the output **FALSE**. For **Cell C7** it will return as-

**2170**

**Conclusion**

I hope all of the methods described above will be good enough to determine if a cell is not blank. Feel free to ask any question in the comment section and please give me feedback.