For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical

COUNTBLANK Function

Counts the number of blank cells within a range


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

COUNTBLANK(range)

  • range  Required. The range in which you want to count the blank cells.

Applies To

Excel 2003 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's COUNTBLANK function

As this example illustrates, the COUNTBLANK function counts only blanks. It ignores all other content, including errors.

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards