The countblank() function does what you might expect — it counts the number of blank cells in a group that you specify. The group can consist of more than one range, such as countblank(a1:b3,a5:b7).