COUNT BLANK In Excel
COUNT BLANK count the cells that are empty or not having any values from the database (array) available in excel sheet. Count Blank will give you the exact result from the selected range that how many cells are empty in this excel sheet. Example shown in the image below.
PARAMETER: = COUNTBLANK ( RANGE )
IMPLEMENT: Use the function to select the range you want to find the blank cell and its done.
FORMULA : =COUNTBLANK(A2:B8)