| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
obatining a total
Will this do it for you?
=COUNTIF(D2:D42,"û") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transferring total sheet from one workbook to another | Excel Worksheet Functions | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| Subtotal | Excel Worksheet Functions | |||
| How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
Hybrid Mode
