Excel function COUNTA

The COUNTA function returns the number of non-empty cells.

Select the COUNTA function and then enter the cell or cells and range or ranges from which you would like to return the number of non-empty cells.

counta function

The function will now display the number of non-empty cells:

counta