COUNT BLANK/NON BLANK FUNCTION
1. The
COUNTBLANK function counts the number of blank cells.
2. The COUNTA function counts the number of nonblank cells. COUNTA stands for count all.
