# How to Find and Count Non-Blank Cells – 4 Methods

This is the sample dataset.

### Method 1 – Using the IF Function to Determine If a Cell Is Not Blank

To see ‘Done’ in non-blank cells and ‘Pending’ in blank cells.

Step 1:

• Select D5.
• Enter the formula:
`=IF(C5<>"","Done","Pending")`
• Press Enter.

Step 2:

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Read More: How to Check If Cell Is Empty in Excel

### Method 2 – Utilizing the ISBLANK Function

To see TRUE in empty cells and FALSE in non-empty cells:

Steps:

• Select D5.
• Enter the formula:
`=ISBLANK(C5)`
• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 3 – Using the IF and ISBLANK Functions

Steps:

• Select D5.
• Enter the formula:
`=IF(ISBLANK(C5),"Pending","Done")`
• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Formula Breakdown:

ISBLANK(C5)

checks if C5 is empty. For blank cells, it returns TRUE and for non-blank cells, FALSE.

FALSE

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

returns Done for FALSE and Pending for TRUE. The output is:

“Done”

### Method 4 – Combining the IF, NOT, And ISBLANK Functions

Steps:

• Select D5.
• Enter the formula:
`=IF(NOT(ISBLANK(C5)),"Done","Pending")`
• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Formula Breakdown:

ISBLANK(C5)

checks if C5 is empty and returns TRUE for blank cells. Otherwise, FALSE

FALSE

NOT(ISBLANK(C5))

returns the opposite value of the output of the ISBLANK function:

TRUE

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

returns Done for TRUE and Pending for FALSE:

“Done”

## Counting the Number of Non-Blank Cells in Excel

### Method 1 – Using the COUNTA Function to Count Non-Blank Cells

Steps:

• Select D14.
• Enter the formula:
`=COUNTA(C5:C12)`
• Press Enter.

### Method 2 – Applying the COUNTIF Function

Steps:

• Select D14
• Enter the formula:
`=COUNTIF(C5:C12,"<>")`
• Press Enter.

### Method 3 – Using the COUNTIFS Function to Calculate the Number of Non-Blank Cells

Steps:

• Select D14.
• Enter the formula:
`=COUNTIFS(C5:C12,">100",C5:C12,"<>")`
• Press Enter.

Download Practice Book

Download the free Excel template.

## Related Articles

<< Go Back to Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

2 Comments
1. This article was very useful. I could learn few useful tips from it.

Advanced Excel Exercises with Solutions PDF