Thursday, October 31, 2013

yogi_Compute Number Of Unique Employees Working on A Task By Month

                                          Google Spreadsheet   Post  #1406
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 31, 2013
question by jessharris318 (http://productforums.google.com/forum/?zx=8pnbo6ums1eh#!category-topic/docs/spreadsheets/CzBz2t6B1fg)
Counting number of Employees. Help!!
Here is a link to what it is I am trying to do:
https://docs.google.com/spreadsheet/ccc?key=0Apa3UMO0fPUPdG1WRVAwcmZiQVhaOVJ1VS1iWFpPdGc&usp=drive_web#gid=2

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
-----------------------------------------------------------------------------------------------