So you might be aware of some useful functions that allow you to count up how many cells have text or a value in it using the COUNT function, you can also count cells based on specific criteria using COUNTIF of COUNTIFS functions. But what if you want to know how many cells are empty because you need to know how much data has not been filled in. For that there is COUNTBLANK.

Here is a video tutorial to show you how to use the COUNTBLANK function.