COUNTBLANK function

The COUNTBLANK function in Excel counts the number of empty (blank) cells in a specified range. This function only considers cells that are completely empty and ignores cells with any data, including spaces, formulas that return an empty string (""), or hidden characters.

Syntax:

COUNTBLANK(range)

Argument:

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

Example:

If you have the following data in cells A1:A5:

A1: 10
A2: 
A3: "Text"
A4: 
A5: 25

Using the formula:

=COUNTBLANK(A1:A5)

This will return 2, because there are 2 blank cells (A2 and A4) in the range.

Key Points:

• Counts only completely empty cells: It does not count cells that contain a formula returning an empty string, or cells with only spaces or invisible characters.
• Can count blank cells across multiple ranges: You can specify more than one range of cells to count the blank cells across.

Use Cases:

• Counting how many cells in a range are empty, especially in data entry forms or when tracking missing information.
• Checking if any cells are unfilled in a dataset.