That is perfect!!! Excellent!

What does the "?" do to the formula? I can see using the wildcard to pickup
anything that is text. Does the "?" just tell it to look at an unlimited
size field?

"RagDyer" wrote in message
...
Try this:

=COUNTIF(A:A,"*?")
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Karl Burrows" wrote in message
...
I converted a column of number cells to text to allow entry of 1a, 1b,
etc.
and need to be able to count the totals of these cells. I can't give it
specific criteria to use DCOUNTA since the text value will vary. Is there
a
way to get a count of non-blank cells in a column of text values?

Thanks!