Then the cells likely aren't really blank. With that formula in place, try
selecting a couple of the "blank" cells and hitting Edit--Clear--All. Save
the file and hit F9.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"gerns" wrote in message
...
I am trying to count text information in a column. Using =CountA
(H1:H500),
the figure comes out much too high.