Do you mean that you want to *COUNT* cells that contain a specific TEXT
entry?

Try something like this...

=COUNTIF(A2:A100,"Yes")

That will count cells in the range A2:A100 that contain Yes.

--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
Is it possible to autosum the total of cells that contain only text, in a
worksheet that contains cells with only text and cells with only numbers?