Counting Blank or Empty Cells in Excel

Excel COUNTBLANK Function

Excel's COUNTBLANK function
Count Blank or Empty Cells with Excel's COUNTBLANK Function.

Ted French

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 contain no data or contain 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.