COUNT BLANK/NON BLANK FUNCTION

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.