I have a query around SUMIFS and whether or not I can use it with a criteria that's delimitated with a ";".
I have a monthly hourly forecast by project, and I'd like to allocate one or multiple resource names to each Project.
I think MS Project does this with ease, but I have a large amount projects with other data and creating two, three or more lines per resource might be too onerous.
Is there a way to sum the allocation of hours by resource by dividing the hours by the amount of names in the resource column?
So where there are 80 hours in P3 for Project 1, Bob and Harry has a sum of 40 hours?