Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.