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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.