Using the Excel COUNTBLANK Function
SummaryThe 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.
Required. The group of cells from which you want to count blank cells.
Usage NotesCOUNTBLANK 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.