Exceljet

Quick, clean, and to the point

Excel COUNTBLANK Function

Excel COUNTBLANK function
Summary 

The Excel COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, etc. are not counted. Formulas that return empty text are counted.

Purpose 
Count cells that are blank
Return value 
A number representing blank cells
Syntax 
=COUNTBLANK (range)
Arguments 
  • range - The range in which to count blank cells.
Usage notes 

Use the COUNTBLANK function to count blank cells in a range, where the word blank means empty. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.

  • Cells that contain text, numbers, errors, etc. are not counted.
  • Formulas that return empty text ("") are considered blank and will be counted.
  • Cells that contain zero are considered not blank and will not be counted.