Count
 

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.

Count
 

try = counta(A2:A100)

"JoJo" wrote:

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.

Count
 

Would COUNTA do it for you?

"JoJo" wrote:

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.

Count
 

=Counta(A2:A100)

--
Regards,
Tom Ogilvy


"JoJo" wrote:

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.

Count
 

=COUNTA(A1:A100)

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


--
Hope that helps.

Vergel Adriano


"JoJo" wrote:

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.

Count
 

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.



JoJo wrote:

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.

--

Dave Peterson

Count
 

Check your other post, too.

JoJo wrote:

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.

--

Dave Peterson

Count
 

If some have numbers:

=COUNTIF(A1:A100,"*")

That will count any cell with text in it.



"JoJo" wrote:

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.

Count
 

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

Regards,

Angine Hazzid

Count
 

Another one:

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

Biff

"suro" wrote in message
ups.com...
Try =countif(a1:a100,"*")

Regards,

Angine Hazzid