- 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.
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.
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.