This example shows you how to count the number of blank and nonblank cells in Excel.
1. The COUNTBLANK function counts the number of blank cells.
CountBlank Function in Excel
2. The COUNTA function counts the number of nonblank cells. COUNTA stands for count all.
CountA Function in Excel

1 comments:

  1. how to calculate 10% in big amount of one of two amount

    ReplyDelete

 
Top