Counting filled cells in excel

A

Alex Wilson

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

Ron Rosenfeld

On Mon, 19 Sep 2005 09:49:37 -0700, "Alex Wilson" <Alex
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?
Click to expand...

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
 
A

Alex Wilson

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
 
A

Alex Wilson

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
 
Top