count if cell if fill with text

C

chiuinggum

if a cell is fill up with text it is consider one count. what is the formula
to use?
 
T

T. Valko

COUNTA will count *all* non-empty cells. Both TEXT and NUMBERS.

To count *only* cells that contain TEXT (this includes formula blanks):

=COUNTIF(A1:A10,"*")

Biff
 
Top