Microsoft Excel COUNTBLANK Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

COUNTBLANK Function Examples

COUNTBLANK Function Definition

Counts the number of non occupied cells (empty cells) in a range of cells.

COUNTBLANK Function Syntax

=COUNTBLANK(range)

COUNTBLANK Function Argument Definitions

range: The range of cells to analyze. Can be a range reference A1:A10 or a name like data.

COUNTBLANK Function Tips

  • Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.