| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding alpha data
I have several staffplans that I use to add weekly hours worked. Is it
possible to set up a formula that will add together staff names to give me a total number of times they appear within the plan? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding alpha data
If you have a list of names in a column and want to know how many times a
givem name appears: =COUNTIF(A1:A100,"Smith") -- Gary''s Student - gsnu200758 "saltod75" wrote: I have several staffplans that I use to add weekly hours worked. Is it possible to set up a formula that will add together staff names to give me a total number of times they appear within the plan? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding zero th alpha numeric value | Excel Discussion (Misc queries) | |||
| Separating Numerical and Alpha Data in cells | Excel Discussion (Misc queries) | |||
| How can I restrict a cell(s) to alpha-only data entry? | Excel Discussion (Misc queries) | |||
| How do I group alpha numeric data in excel? | Excel Discussion (Misc queries) | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
