Average % complete if task is assigned to "xxx"

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.

Find more posts tagged with

Formulas

Project Management

Comments

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!