Thread: Wildcard Function in sumproduct

Hi Whizbang,

You are probably right. As mentioned, I was messing around with my worksheets & there may be a slight variation of results. Regardless, I'm still seeking the same functionalities.

Thanks

Hi,

You are probably right! As mentioned, I was messing around with my worksheets a little bit & therefore, the results may vary.

However, the intents of functionalities to get the same results still remains the same.

Thanks

Our discussions seems to be crossing paths a little bit.

Here's an (updated file).

Hi Whizbang,

In some instances, the columns are providing the correct results.

If reviewing / filtering Supervisor 3 & 7 in the task log & reviewing results in rows 48 & 49 of the TATs worksheet:

* The Current # of Pending Tasks column works well

* # of Tasks Column

Supervisor 3 - I think I should be seeing 0 because it does appear that any tasks are due during this specific week - 06/20 - 06/26

It's counting 1 & I don't see where it's getting its result

For Supervisor 7

* The result is 2 & it looks like it should be 1 because only on tasks falls within date range

The more I look at this, the more I think I want to change the calculations for On-time & Late calculations.

Right now, I'm looking for the specific week durations, but I don't think my end chart (that I will have) will be truly representative to the individuals on-time / late deliverable statuses

Ooops,

Submitted before I was done...

- As for the On-Time & Late status, I think I'll open up those date ranges & calculate the planned finish dates vs. actual finish date.

Thanks