The empty cells are not really blank, they are pulled from a database
worksheet using a formula, so their value is "". I tried it and it counted
all the cells as having a value.

"Govind" wrote in message
...
Hi,

If you want a count of non-blank cells in a column of text values use
=COUNTA(range)

Regards

Govind.

Karl Burrows wrote:

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!