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.
|