|
COUNTBLANK function
|
|
COUNTBLANK is one of the COUNT functions but this time we can count the number of cells that are empty. COUNTBLANK function Exercises1. 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 >> |