Returns the number of elements of the given array which are either blank or are equal to the empty text string. COUNTBLANK ({ 10, BLANK (), "" }) COUNTBLANK ({ 10; BLANK (); "" }) returns 2, because BLANK () BLANK () and the empty text string "" are considered blank.

Unlike the COUNT and COUNTA functions, this function accepts a single parameter, which must be an array.

Count anything

Using a combination of FILTER and SIZE, you can use any criteria you like. Consider this formula:

The formula above returns a version of NumberArray where only elements greater than 4 are included. Use the SIZE function to count the number of elements in the returned array:

The formula above returns the number of elements of NumberArray which are greater than 4.

It's easy to replicate what COUNTBLANK does armed with this knowledge, and the fact that ISBLANK can be used to determine if an array element is blank:

The formula above returns the number of array elements which are blank or are equal to the empty text string, which is exactly what COUNTBLANK does. This formula uses the || "logical or" operator, which is equivalent to the OR function in non-array contexts.

Counting can also be done with REDUCE. Here's the equivalent REDUCE formula:

Refer to the REDUCE documentation to learn more about how this example works (specifically, this example is similar to the XOR example in that documentation).