Learn how to use the Excel COUNTBLANK function with syntax and examples.
The Microsoft Excel COUNTBLANK function counts the number of empty cells in a range.
The syntax for the Microsoft Excel COUNTBLANK function is:
COUNTBLANK( range )
range is the range of cells to count empty cells.
The COUNTBLANK function can be used in the following versions of Microsoft Excel:
The COUNTBLANK function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel COUNTBLANK function examples and explore how to use the COUNTBLANK function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel COUNTBLANK examples would return:
=COUNTBLANK(A1:A4) Result: 1 =COUNTBLANK(A1:A6) Result: 3 =COUNTBLANK(A1:B4) Result: 3