Hi,

Can someone please assist. This function is partially working if it meets a specific criteria.

I'm not sure if there's something missing or incorrect or if there's a better function do the same type of thing.

As mentioned above, I'm seeking:

* A name in a Task Ownership column - May be 1 owner or multiple
* In my data collection table, I have a cell with the individual's name. Now, I'm seeking this person's name within a specified date range & sum the total tasks assigned to this particular individual.
-- Typically within a weekly duration

What am I missing or what do I need to modify? Does a Sumif or VLookup work? I would still need to find a single individual / name that may be amongst several others within in the Task Owner(s) column.

Thanks