Statistical non-null cells in excel, you can use the COUNTA function to achieve.
Example image:
As shown in the figure above, in the E column corresponding to the cell enter the formula: = COUNTA (D: D), note that the function statistics are non-empty cells, spaces, empty text (""), the error value, and invisible characters will also be counted.