Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

The COUNTBLANK function provides us with a way to count the number of cells within a given cell range that are blank.

This is the syntax of the function:


range : They are the cell references or cell ranges within which you want to count the blank cells.

Empty cells (“”) are counted as blank, but zero value cells are not counted.

Click on the button to practice using this function, with the help of our Online Assessment Tool:


Here is an example of how to use the COUNTBLANK function:

Use the countblank function in the cell B1 to count the blank cells in the cell range A1:A400.

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>