View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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.