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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas