Excel Function

COUNTBLANK

Counts blank cells in a range.

COUNTBLANK(range)

Arguments

range

Required

Specify the range used for condition check or aggregation.

Practice Preview

summarize sales data. Use COUNTBLANK to Counts blank cells in a range. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=COUNTBLANK(B2:B8)

Practice This Function

Practice in Sequential Mode Back to Function List