Which function counts blank cells?

In Microsoft Excel, the COUNTBLANK(range) function is specifically designed to count the number of empty or blank cells within a given range. Blank cells include those that are truly empty or contain formulas returning an empty string ("")

For example, if cells A1–A5 contain: 10, "", (empty), 5, "Text", then the formula =COUNTBLANK(A1:A5) returns 2, for the empty and the empty-string cells .

Here's a look at the other options:

• 
  

  COUNTEMPTY(): Not a valid Excel function.

  
  


• 
  

  COUNT(): Counts only numeric values.

  
  


• 
  

  BLANK(): Also not a valid function.

  
  

Understanding COUNTBLANK() is essential for identifying gaps, missing data, or null entries in datasets.