I have a report that I have created that obtains its information from another
worksheet. My data consist of projects, tasks, employees, hours, etc.
I currently have a formula that counts the number of resources (employees)
that have clocked time against a certain task on a certain project but it
only counts each employee once on each tasks.
My Data (Data!)
Column A - Employees (Resources)
Column B - Date Time Clocked
Column C - Hours
Column D - Project
Column I - Task

On my report I have this formula:
=COUNTDIFF(IF(Data!$D$2:$D$3288=$A$3,IF(Data!$I$2: $I$3288=$A11,
Data!$A$2:$A$3288)),,FALSE)
A3 and A11 on my report corresponds to the project and task within my data
columns D and I. This formula is working fine and doing what it is supposed
to so far. But I need to take it a step further. I need to know the number
of resources that have currently worked (within last 7 days from today) on a
particular project and task as well. I tried inserting an IF statement at
the beginning IF((Data!$B$2:$B$3288$A$1-7) with A1 being todays date but it
gives me an incorrect number.
Any help would be greatly appreciated.

It actually returns the answer FALSE. What I am wanting is if there are no
resources working on that project and task for it to return "0" not FALSE. I
tried replacing "0" in place of the word FALSE in the formula but the answer
stays the same?
Help.

"Gayla" wrote:

I have a report that I have created that obtains its information from another
worksheet. My data consist of projects, tasks, employees, hours, etc.
I currently have a formula that counts the number of resources (employees)
that have clocked time against a certain task on a certain project but it
only counts each employee once on each tasks.
My Data (Data!)
Column A - Employees (Resources)
Column B - Date Time Clocked
Column C - Hours
Column D - Project
Column I - Task

On my report I have this formula:
=COUNTDIFF(IF(Data!$D$2:$D$3288=$A$3,IF(Data!$I$2: $I$3288=$A11,
Data!$A$2:$A$3288)),,FALSE)
A3 and A11 on my report corresponds to the project and task within my data
columns D and I. This formula is working fine and doing what it is supposed
to so far. But I need to take it a step further. I need to know the number
of resources that have currently worked (within last 7 days from today) on a
particular project and task as well. I tried inserting an IF statement at
the beginning IF((Data!$B$2:$B$3288$A$1-7) with A1 being todays date but it
gives me an incorrect number.
Any help would be greatly appreciated.