Excel COUNTBLANK Function

Using the Excel COUNTBLANK Function


The Excel COUNTBLANK function returns a count of blank cells in a range, including formulas that return empty text. The function does not count cells that contain text, numbers, dates, or error values.



Syntax Breakdown

Required. The group of cells from which you want to count blank cells.

Usage Notes

COUNTBLANK counts the number of blank cells in a specified range. Blank should be understood as empty. Therefore, cells containing text, numbers, dates, zero values, or error values are ignored. Cells that contain a formula that returns empty text ("") will be included.

Other count function exist that will count non-blank cells. See the COUNT, COUNTA, and COUNTIFS functions for more information.