## Thursday, October 31, 2013

### yogi_Compute Number Of Unique Employees Working on A Task By Month

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 31, 2013
Counting number of Employees. Help!!
Here is a link to what it is I am trying to do:

There are 3 sheets:
First: the "Employee Production Tracking" Sheet - this is what I am trying to have count the number of different employees that completed tasks each month.
Second: the "Task Log" - This is what the employees will be filling in. They put in the task name (which is irrelevant for what I am trying to track on the first sheet), the name of the employee who completed it, and the month the task was closed in.
Third: The list on employees in Column A and which "division" they work for in Column B (as I need to track this as well).

I need to count how many different employees completed tasks in each month. Then I need to break it down and count how many different employees from each division completed tasks in each month.

For Example: in July, 6 tasks were completed, but what I need to know in Column B of the Employee Production Tracking sheet is that 3 different employees completed tasks in the month of July on this project. And then for columns C and D I need to know how many (of those three employees) were from division A and from division B. On the Employee Lists sheets it has a running tab of all employees working on this project in column A and what division they work for in column B.

I used [=COUNTUNIQUE(FILTER('Task Log'!B:B,'Task Log'!C:C="January"))] for the total number of employees for each month, BUT for the months that nothing has been completed yet it is returning a value of 1. How do I have it return a value of 0 for those months where nothing has (yet) been completed?

Is this possible or am I asking too much of Google?? :)

Thanks in advance for your help, I really appreciate it as I am stumped on this one.

Jessica
-----------------------------------------------------------------------------------------------