How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Compute Expert

How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps


Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps





In this tutorial, you will learn how to use the COUNTBLANK function in excel completely.

When working in excel, we sometimes need to know how many blank cells do we have in a cell range. COUNTBLANK can help you to get that kind of information fast.

Want to understand more about the way to use this formula in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







What is the COUNTBLANK Function in Excel?

COUNTBLANK function is an excel function you can use to count the number of blank cells in a cell range. Blank cells here mean the cells contain empty data. That includes cells that contain empty text (we usually represent empty text with empty double quotes ( “” )).



COUNTBLANK Usability

You can use COUNTBLANK to get the number of blanks you have in a specific cell range.



COUNTBLANK Result

The COUNTBLANK result is a number that represents the number of blank cells in the cell range you input into COUNTBLANK.



Excel Version from Which We Can Start Using COUNTBLANK

We can start using COUNTBLANK since excel 2003.



The Way to Write It and Its Input

Here is the general writing form of a COUNTBLANK formula in excel.

= COUNTBLANK ( cell_range )


The only input you give to COUNTBLANK is the cell range you want to count the number of blank cells of.

Unlike other count formulas in excel (COUNT, COUNTA, etc), you can only input one cell range to COUNTBLANK.



Example of Its Usage and Result

Here is the implementation example of COUNTBLANK in excel.

How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of the COUNTBLANK Implementation Example

As you can see in the example, we only need to input the cell range we want to process to COUNTBLANK. As the blank cells in the cell range input here are two, that is the number that COUNTBLANK returns to us.

Learn Excel Dashboard Course



Writing Steps

After we have discussed the COUNTBLANK writing form, input, and implementation example, now let’s discuss its writing steps. As the input COUNTBLANK needs is only one cell range, you should be able to understand its writing steps quite easily!

  1. Type equal sign ( = ) in the cell where you want to put your COUNTBLANK result

    How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of Step 1

  2. Type COUNTBLANK (can be with large and small letters) and an open bracket sign after =

    How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of Step 2

  3. Input the cell range you want to count the number of blank cells from

    How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of Step 3

  4. Type a close bracket sign

    How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of Step 4

  5. Press Enter
  6. Done!

    How to Use the COUNTBLANK Function in Excel: Usabilities, Examples, and Its Writing Steps - Screenshot of Step 6



Learn Excel Dashboard Course



Exercise

After you have learned how to use the COUNTBLANK formula in excel, now let’s do an exercise. This is so you can practice the lessons you have got from this tutorial!

Download the exercise file and answer all of the questions below. Download the answer key file if you have done the exercise and want to check your answers.

Link to the exercise file:
Download here

Questions

Use COUNTBLANK to answer each of the questions below!
  1. How many blank cells are there in the product name column?
  2. How many blank cells are there in the stock quantities and today’s sales columns?
  3. How many blank cells are there in the product name, stock quantities, and today’s sales column?

Link to the answer key file:
Download here



Additional Note

COUNTBLANK won’t count zero numbers, spaces, or errors in the cell range you input into it. It will only count empty cells and cells with empty data (cells that contain empty quotes).



Related tutorials you should learn from:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert