Average % complete if task is assigned to "xxx"

Jeff Smith

What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned to user XXX. 

Jeremy Michels

do you list each user under a parent row to seperate them. This would allow you to do what you are working on. 

Jeff Smith

Here is a screen shot of part of the project plan. 

Travis

Hi Jeff, I built a formula to get the average % Complete for a specified user.

 

=(SUMIF(CHILDREN([Assigned To]3), "DCI", CHILDREN([%  Complete]3))) / (COUNTIF(CHILDREN([Assigned To]3), "DCI"))

 

This will first sum the % Complete values if the Assigned to is DCI then divides it by the number of tasks DCI is assigned it. 

 

Enjoy! 

Jeff Smith

Thanks Travis. I swear I will get these formulas down one day.