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
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
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.
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.
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!-
Type equal sign ( = ) in the cell where you want to put your COUNTBLANK result
-
Type COUNTBLANK (can be with large and small letters) and an open bracket sign after =
-
Input the cell range you want to count the number of blank cells from
-
Type a close bracket sign
- Press Enter
-
Done!
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!- How many blank cells are there in the product name column?
- How many blank cells are there in the stock quantities and today’s sales columns?
- 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:
