Count

[Guest]

Folks:



I have a single column of information. Only SOME of the cells within this
column contain a string of alphabetic characters.
Some cells are empty. For example:

Column A
ABC

ZEP


POW
ZAP


* What Excel command would allow me to count the # of cells that actually
contain alphabetic information within a certain range like A2:A100



Thanks,
John.

 

[Guest]

try = counta(A2:A100)

 

[Guest]

Would COUNTA do it for you?

 

[Guest]

=Counta(A2:A100)

 

[Guest]

=COUNTA(A1:A100)

will give you the count of non-blank cells in the range.

 

[Dave Peterson]

If those empty cells are really empty, then you could use:

=counta(a2:a100) to count the non-empty cells.

Cells with Text, Numbers, and even formulas that evaluate to "" will be counted.

 

[Dave Peterson]

Check your other post, too.

Folks:

I have a single column of information. Only SOME of the cells within this
column contain a string of alphabetic characters.
Some cells are empty. For example:

Column A
ABC

ZEP

POW
ZAP

* What Excel command would allow me to count the # of cells that actually
contain alphabetic information within a certain range like A2:A100

Thanks,
John.

 

[Guest]

If some have numbers:

=COUNTIF(A1:A100,"*")

That will count any cell with text in it.

 

[suro]

Try =countif(a1:a100,"*")

Regards,

Angine Hazzid

 

[T. Valko]

Another one:

=ROWS(A2:A10)-COUNTBLANK(A2:A10)

Biff