ExcelBanter - obatining a total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - obatining a total (https://www.excelbanter.com/excel-discussion-misc-queries/123904-obatining-total.html)

obatining a total

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.

obatining a total

=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.

obatining a total

Will this do it for you?
=COUNTIF(D2:D42,"û")