Getting the most out of the COUNTBLANK Function

abstract ancient antique art

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This post will teach you all about the COUNTBLANK function and how to get the most out of it. We will explore its purpose, its formula syntax, the constraint under which it is used, and also an example where you can experiment with it to help you apply it to your particular needs.

The purpose of the COUNTBLANK function (also one of the Statistical functions) is to count how many blank cells there are within a cell range.

A blank paper - symbolises the COUNTBLANK function.
Image by Juraj Varga from Pixabay.

Syntax of the COUNTBLANK Function


The COUNTBLANK function syntax contains this listed argument:

  • Range  –  Required. The desired range whereby you are looking to count the empty cells.
An empty gallery to represent the COUNTBLANK function.
Image by Danielle Papanikolaou from Pixabay.

Remark of the COUNTBLANK Function

Cells including formulas that bring back “” (empty text) are even taken into account. However, more importantly, cells containing zero values are skipped.


Copy the sample data in the table below, and paste it into cell A1 of a brand new Excel worksheet.

=COUNTBLANK(A2:B5)Counts empty cells in the range above.2

Note: Copying from some browsers might insert an apostrophe to the outset of the formula once it’s pasted in Excel. If the formula presents no result, pick that cell, press F2, erase the apostrophe, and then press Enter.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Overview of formulas in Excel

How to avoid broken formulas

Find and correct errors in formulas

Excel keyboard shortcuts and function keys

Statistical functions (reference)

(Alphabetical) Excel functions

(By category) Excel functions

Excel Tutorial Homepage

Leave a Reply

%d bloggers like this: