I need Help with a count cell text formula
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
|