COUNT BLANK count the cells that are empty or not having any values in the database (array) available in excel sheet. Example As Shown In Image=COUNTBLANK(A2:E6)To learn more please visit Excelhelp.in