COUNTBLANK function

Category: Statistical functions

What does this function do?

Count the number of cells in a range that are empty.

Syntax:

COUNTBLANK(value1, [value2], ...)

• value1 (required): The first argument representing the values that you want to count.

• value2 (optional): Additional arguments representing the values that you want to count, up to a maximum of 255 arguments.

Examples:

=COUNTBLANK(A1:A3,B1) = 3 if A1:A3 = {2,””,4} and B1=1