Counting The Number of Employees

  • Thread starter Thread starter Matlock
  • Start date Start date
M

Matlock

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.
 
Try this (using proper range for your list of names, I've assumed in column B)
=COUNTIF(B1:B99,">=A")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Numbering Sequence 3
Count specific text only if adjacent cell is blank? 3
Countifs and date comparison 3
Excel Countif formula employees who retire before 01/04/2018 2
Count Distinct 7
Excel Formula - Count Dates from another Sheet 8
How to do a formula counting the number of hours between 2 times? 2

Back
Top