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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why doesn't excel count function update automatically? 1
Count with merged cells 2
sum to recognize new rows 3
Counting cells containing formulas with blank results 3
how to count this in this unusual situation 2
CountA question 2
ignore formulas in dynamic range 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Back
Top