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.

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