Returns the number of non-empty values (numbers or text) in a range.
=COUNTA(A1:A10) counts all filled cells in A1:A10.