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.

COUNTBLANK function counting empty cells

Follow us on

Facebook  Twitter  You Tube 

Other Statistical Functions

Excel 2010 Superhero Course