Sorry I should have explained, there's 16,000 cells in each col. and some of
them have text in them and others don't appear to have anything but they
don't show up as not having anything under countif or countta. I can't clear
the cells otherwise I would lose the data and due to the number of cells it
is impratical to go down and select each one and clear it.

Thanks,

Alex

"Anne Troy" wrote:

> Select those "blank" cells and hit Edit-->Clear-->All, then save the file.
> Does that help the counta?
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Alex Wilson" <AlexWilson@discussions.microsoft.com> wrote in message
> news:5BF0D29A-B21E-4F90-97BF-7CA13398332A@microsoft.com...
> > No I don't, the cells seem to have something in them, but when I click on
> > them there's nothing there, not even a " " (Space). All I'm after counting
> > is
> > weather they have text in them.
> >
> > Thanks
> >
> > "Anne Troy" wrote:
> >
> >> So do you want to count the unseen or not?
> >> ************
> >> Anne Troy
> >> www.OfficeArticles.com
> >>
> >> "Alex Wilson" <Alex Wilson@discussions.microsoft.com> wrote in message
> >> news:B4E6F013-3E3C-460A-8D29-C8A69DE2A444@microsoft.com...
> >> > I'm trying to count then number of cells with data in them, however the
> >> > =countta and =countif don't seem to work as some of the cells are
> >> > filled
> >> > with
> >> > something unseen. They arn't filled with spaces, and the cells that I
> >> > am
> >> > counting have different text entries, so I can't use countif (text
> >> > entry).
> >> > Any suggestions?
> >> >
> >>
> >>
> >>
>
>
>