count formula help

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

Anybody know a formula that will count only text in a
range of cells? I did a counta but when I delete content
in the blank cells the cells number changes?

Thanks in Advance.
 
=COUNTIF(A1:A4,"*")
I guess I understand your question. Just list your text in the cell
and do a countif function.

Hope that helpe
 
Use this

=COUNTIF(A1:A15,">=a")

Count Range is A1:A15 amd the 2 arg MUST be in QUOTES.

Numbers in this range won't be counted but Caps and lower
case ascii characters will.
 
Back
Top