Excel > Functions

COUNTBLANK Function

The COUNTBLANK function counts the empty cells in a given range.

The syntax for the COUNTBLANK function is:

=COUNTBLANK(range)

Argument	Purpose
Range	the range of cells you want to count

The example below demonstrates the COUNTBLANK function being used to count a range of cells.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides