Excel COUNT, COUNTA and COUNTBLANK Functions
With the help of Count function you can count the number of cells that contain number, CountA function counts the number of nonblank cells and blank find out the number of blank cells in range/area respectively.