add cells with data

J

JB

Hello all.
I'm trying to find the formula to count how many cells have data.
i.e. I have a Colum which will have data in some of the cells but not all.
The value of the data equals 1, but I have to put a description rather than
the number.
Does any one know?
Thank you
Jen
 
B

Bernard Liengme

Have you looked in Help to see how COUNT and COUNTA work?
Tell us what some sample data might look like
 
C

CLR

Assuming your Descriptions are in column A, put this in B1

=COUNTA(A:A)&" Descriptions"

It will count 1 for every cell in column A that contains a description.

Vaya con Dios,
Chuck, CABGx3
 
J

JB

Thanks for that. It worked a treat. I did look in Help but was typing Counta
and not COUNTA.
 
Top