If A1 thru A10 contain either text or formulas returning a blank, then:

=COUNTA(A1:A10)-COUNTBLANK(A1:A10)

--
Gary''s Student - gsnu200800


"Paul H" wrote:

I would like to count the text in a column, (each text would count as 1), the
column contains a simple "If" statement that will return either a name or a
blank. The text counting solutions I see in these posts also count the If
statement as 1.