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*