Counting Blank or Empty Cells in Excel

Excel COUNTBLANK function

Excel's COUNTBLANK function

 Ted French / Lifewire

Excel offers several count functions that quantify the number of cells in a selected range that contain a specific type of data.

The job of the COUNTBLANK function is to count the number of cells in a selected range that either contains no data or contains a formula that returns a blank or null value

Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, comma separators, and arguments.

The syntax for the COUNTBLANK function is:

=COUNTBLANK(range)

The range, which is a required argument, is the group of cells the function must search. The range argument must be a contiguous group of cells.

Since COUNTBLANK does not permit multiple ranges to be entered for the range argument, several instances of the function may be entered in a single formula to find the number of blank or empty cells in two or more non-contiguous ranges. For example:

=COUNTBLANK(A2:A10) + COUNTBLANK(B2:B10)

Alternative Using CountIf

Excel supports more than one way to arrive at your intended, correct answer. For example, the formula

=COUNTIF(A2:A10,"")

uses the COUNTIF function to find the number of blank or empty cells in the range A2 to A10 and gives the same results as COUNTBLANK.