COUNTBLANK Function in Excel

COUNTBLANK function is a formula used to count the number of empty cells within a specified range. It helps you determine how many cells in a given range do not contain any data, text, numbers, or formulas.

Syntax 

COUNTBLANK(range)

range: This is the range of cells you want to count the blank cells within. It can be a single cell reference, a range reference, or an array.

 

Scroll to Top