This example will demonstrate how to count the number of blank and non-blank cells in Excel.
Function COUNTBLANK (COUNTBLANK) counts the number of empty cells:
=COUNTBLANK(A1:A7)
=СЧИТАТЬПУСТОТЫ(A1:A7)
Function COUNTA (COUNTA) counts the number of non-empty cells:
=COUNTA(A1:A7)
=СЧЕТЗ(A1:A7)