Countblank function in Excel

new dictionary define in office corner combin combination

Software Articles Templates Dictionary Home

COUNTBLANK function

COUNTBLANK is one of the COUNT functions but this time we can count the number of cells that are empty.

Countblank Excel function

If we use =COUNTBLANK(A1:A12) we will get 3 as a result of counting. We can use COUNTBLANK on any range of cells.

In this example we have multicolumn value result. We can type =COUNTBLANK(A1:C11) and the result we'll be 11

For other COUNT functions look at: COUNTA, COUNTIF

COUNTBLANK function Exercises

1. Imagine you found new coold online game and have to create 10 names for your 10 new characters. Enter different values from A1 to A10, leave few cells empty. Use =COUNTBLANK(A1:A10). You we'll get number of names you forgot to create.

2. This time you have a task to create passwords for your user. Type mixed data in column A from A1 to A5, in B1 to B3 and in C3 to C5. At C6 use =COUNTBLANK(A1:C5). The result we'll be the number of cells where there is no data.

Check all Beginner's Tips
Learn how to use Excel functions and formulas
in three steps of difficulty >>