Totaling text cells

[Malcolm]

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?

 

[T. Valko]

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.

 

[Gord Dibben]

=COUNTA(range of cells)-COUNT(range of cells)


Gord Dibben MS Excel MVP