Thread: modified:YTD Totals

Hi,

I'm trying to figure out individual(s) YTD (Year-to-Date) Totals of on-time & late deliverable statuses

I have 2 worksheets, as follows:

Task Log Worksheet
-- Used to list task, assign supervisor(s) & Engineer(s) - In some instances, there may be 2 Supervisors or Engineers assigned to the same tasks, so a "search" function is required, which I kind of have.

Supervisor TATs (Turn Arond Time) Worksheet
-- Use to complile info. from my Task Log on a weekly-individual basis, then later as a team

Right now, I need assistance with getting functions working in Row 48

In column - Current # of Pending Tasks, the function is working corretly or no issues

However, in columns:

# of Tasks Due This Week
-- Not finding individual if assigned with another individual, in this instance a supervisor
-- Finding a signle individual, seems to work o.k.

Currently using:
IF(G48="","",SUMPRODUCT(--('Task Log'!$Q$13:$Q$570>=I48),--('Task Log'!$Q$13:$Q$570<=J48),--(ISNUMBER(SEARCH(G48,'Task Log'!$O$13:$O$570)))))

-- In Columns, On-Time & Late, I'm seeking to modify the function so it will find the individual, regardless if assigned to multiple task & find YTD totals up to the current week.

Currently using:

On-Time
=IF(G48="","",SUMPRODUCT(--('Task Log'!$S$13:$S$570<=J48),--(ISNUMBER(SEARCH(G48,'Task Log'!$O$13:$O$570)))))


Late
=IF(G48="","",SUMPRODUCT(--('Task Log'!$S$13:$S$570>J48),--(ISNUMBER(SEARCH(G48,'Task Log'!$O$13:$O$570)))))

How can these be modified to get it to calculate correctly?

I would also lke to get the Weekly TAT % working, but I should be able to figure that out once I get my On-Time & Late YTDs adding / summing up correctly.

I attached an Excel 2007 file for example.

Thanks

Ooops,

I hate when I do that.... Here's the file....