Sum text

K

Ken

I have a large amount of text in Coulmns. I would at the bottom of each
column I would like to get a total count of how many cells in the column
contain data. The column sum value would be something like A2:A250 .. Thanks
 
M

mikebres

Read up on the COUNTA function in help. Essentially you would use

=COUNTA(A1:A20)

Mike
 
R

Ron Rosenfeld

I have a large amount of text in Coulmns. I would at the bottom of each
column I would like to get a total count of how many cells in the column
contain data. The column sum value would be something like A2:A250 .. Thanks
Click to expand...

Look at the COUNTA worksheet function
--ron
 
Top