Try this

=SUMPRODUCT(--(ISTEXT(A1:A100)))

Mike

"Excel ??" wrote:

Dear all, can anyone please please give me a formula or how do I add cells
that contatin text not numbers? I want to be able to add each cell that
contains text and for those that are blank of course not to be added to my
sum. thank you all I hope I made sense.
--
2