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
Bookmarks