| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting The Number of Employees
Howdy,
I'd like to know is there is a formula to counting the number of Employees I have. Each cell though, has a formula in it, to display the name of the Employee. Basicly, it needs to count the number of names listed, and not the formulas in the cells. I have been using =COUNTIF(R5:X5,"0") to count the number of days an employee works, but not sure hot to configure it to count the names, if even possible. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting The Number of Employees
Try this (using proper range for your list of names, I've assumed in column B)
=COUNTIF(B1:B99,"=A") "Matlock" wrote: Howdy, I'd like to know is there is a formula to counting the number of Employees I have. Each cell though, has a formula in it, to display the name of the Employee. Basicly, it needs to count the number of names listed, and not the formulas in the cells. I have been using =COUNTIF(R5:X5,"0") to count the number of days an employee works, but not sure hot to configure it to count the names, if even possible. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number when you have a number and text | Excel Worksheet Functions | |||
| Number of employees working at given time | Excel Discussion (Misc queries) | |||
| Counting number of grades in a row | Excel Worksheet Functions | |||
| Number Counting | Excel Discussion (Misc queries) | |||
| Number of employees in the appropriate time column | Excel Worksheet Functions | |||
Linear Mode
