Excel - COUNTBLANK Function: Counting Empty Cells - Examples and Usage

Buzz

Ngày cập nhật gần nhất: 15/4/2026

The COUNTBLANK function in Excel is used to count the number of empty cells in a selected range or array effectively.

The syntax and usage of the COUNTBLANK function in Excel are simple yet have significant applications in calculations and statistics. However, not everyone understands the meaning and usage of this function clearly. This article by Mytour will guide you on how to use the COUNTBLANK function.

GUIDE TO USING COUNTBLANK FUNCTION IN EXCEL - ILLUSTRATIVE EXAMPLES

Syntax: COUNTBLANK(Range)

Where:

Range: The selected array to count the number of empty cells in.

Note: 0 is not considered blank (empty cell).

Illustrative Example: Consider a list of students who either received or did not receive scholarships.

Students not receiving scholarships are represented by empty cells. Count the number of students not receiving scholarships in the group.

The formula in cell B11 is : =COUNTBLANK(C5:C9)

We obtain the result:

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]