COUNT

=COUNTIF(A:A140,"*")

Count number of cells in column with text