{"id":1073,"date":"2019-05-03T17:37:03","date_gmt":"2019-05-03T14:37:03","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1073"},"modified":"2019-05-03T17:37:06","modified_gmt":"2019-05-03T14:37:06","slug":"the-countblank-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-countblank-function\/","title":{"rendered":"The COUNTBLANK function"},"content":{"rendered":"\n

The COUNTBLANK <\/strong>function provides us with a way to count the number of cells within a given cell range that are blank. <\/p>\n\n\n\n

This is the syntax of the function:<\/p>\n\n\n\n

COUNTBLANK(range)<\/strong><\/p>range<\/span><\/font> <\/strong>: They are the cell references or cell ranges within which you want to count the blank cells.

<\/cite><\/blockquote>\n\n\n\n

Empty cells (“”) are counted as blank, but zero value cells are not counted.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the COUNTBLANK function:<\/strong><\/p>\n\n\n\n

Use the countblank function in the cell B1 to count the blank cells in the cell range A1:A400.<\/p>\n\n\n\n

\n