counting total cells with text

P

peace

Hi , I have a column with text and blanks and I am trying to count the
total number of cells with text. I searched through this site and
found something with COUNTA() - COUNT() but this doesn't work because I
have no numerical values. Any ideas are sincerely appreciated


Thank you
 
C

CLR

Your original formula will work even tho there are no numerical values,
however, this will do it by itself.
(Substitute your column designation for A:A)

=COUNTA(A:A)

Vaya con Dios,
Chuck, CABGx3
 
C

Cutter

Bear in mind that COUNTA(A:A) will return not only the number of cell
that contain text but also the number of cells that contain formulas.
If you have formulas returning the "" result to make your cells loo
like they're blank then you won't be getting an accurate count of cell
containing text only
 
P

peace

Thanks to all those who responded. Cutter is right, counting cells with
formulas that return blank values gives the wrong total number of cells
with text. Is there some sort of trick I can use for this?

Thanks again
 
C

Cutter

One solution is to have a helper column somewhere with the formula:
=IF(LEN(A1)>0,1,0)
Copy the formula down as far as is needed.
Then do a SUM() on that helper column
 
C

cardingtr

sorry to butt in, but I have the same issue, well almost, how do you
count only the cell that has specific text?
Like count only cells with "7p" and "7a" but not "off", or "sick" or
"vacation"?

Thanks.
 
Top