Arrow left
Back to guides
Excel Formulas

COUNTBLANK Function in Excel: Explained

In this article, you will learn how to use the COUNTBLANK formula in Excel.

What does the COUNTBLANK function do in Excel?

The COUNTBLANK function in Excel counts the number of blank cells within a specified range.

When is the COUNTBLANK function beneficial in Excel?

The COUNTBLANK function can be beneficial in Excel when you need to quickly determine the number of empty cells within a specific range. For example, if the COUNTBLANK function returns a value equal to or greater than 1, there is at least one blank cell in the selected range. It helps find missing data and monitor data quality in your spreadsheets.

How to use the COUNTBLANK formula in Excel?

The general syntax of the COUNTBLANK formula is as follows:


range: This is the range in which you want to count the number of empty cells

Note: The COUNTBLANK function considers cells embedding ”” (empty string) as empty cells.

Assume you have the following dataset in the picture below and want to know the number of “No response” by counting the number of empty cells with the following formula.


The formula should return 2, as there is one cell containing nothing (cell C4) and another cell incorporating ”” (empty string) (cell C7), both of which are highlighted in blue. Note that a space is considered a value; thus, the formula recognizes cells containing only space as non-empty cells.

How to use the COUNTBLANK formula in Excel with an example

What is the difference between the COUNTA and COUNTBLANK functions?

The difference between the COUNTA and COUNTBLANK functions in Excel is that the COUNTA function counts the number of non-empty cells in a range. On the other hand, the COUNTBLANK function calculates the number of empty cells (cells with no data) in the selected field.

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly. 

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below