Do you mean count the characters?

If so

=SUM(NOT(ISNUMBER(A1:A20))*LEN(A1:A20))

as an array formula (committed with Ctrl-Shift-Enter)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter Curtis" wrote in message
...
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria

Thanks!