=COUNTA(D2:D42)
--
Gary''s Student


"Florida Richard" wrote:

heres the problem, I have a spread sheet that shows a workers pr number in
one column, there first review in a second column and other info. In the
columns for the 1st, 2nd, etc i use a ascii 251 checkmark code. What i am
trying to do is be able to automatically calculate in a cell at the bottom
the total number of cells in a column that is filled. d2 through d42 are the
cells in question and d44 is where i would like the total to be. If anyone
could help I would appreciate it.