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

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

Another:

=counta(a1:b99) - count(a1:b99)

=counta() will count all the non-empty cells (even cells with formulas that
evaluate to "")

=count() will count the numeric cells.



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

--

Dave Peterson

This will count TEXT, *including* nulls ( "", zero length strings):

=COUNTIF(A:A,"*")

This will *not* count nulls:

=COUNTIF(A:A,"*?")


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Excel ??" wrote in message
...
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

I suspect you mean count not sum:

=COUNTA(A1:A9)

But if the cells contain numbers this will also count them. Don't know if
that is an issue?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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