Counting filled cells in excel

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?

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

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

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

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

On Mon, 19 Sep 2005 09:49:37 -0700, "Alex Wilson" <Alex
Wilson@discussions.microsoft.com> wrote:

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

IT depends on what's in those cells.

But this might work if the cells have a null string, perhaps as the result of a
formula:

=SUMPRODUCT(--(LEN(A1:A100)>0))


--ron