Hi All
I am trying to do the following and I'm struggling, I have a series of rows to track project steps, I need a sum of hours to be added up against each user assigned to task, but exclude the rows where the task Status is "Complete"
Row Headers below: -
Status ($F$6:$F$45)
Task Owner ($K$6:$K$45)
Actual Estimate ($M$6:$M$45)
The idea being, I choose who is allocated the task (Column K), fill in the estimated time for that task (Column M), and it then adds up the total effort for that individual, but I need it to exclude the row from the count when the "Status" (Column F) reads "Complete"
Below is where I plan to summarise each persons total effort, and the initial formula I used to search for the person and to the adding up.
=SUMIF($K$6:$K$45,"*Name of user assigned task*",$M$6:$M$45)
Hoping you can help,
Thanks
Bazola
I am trying to do the following and I'm struggling, I have a series of rows to track project steps, I need a sum of hours to be added up against each user assigned to task, but exclude the rows where the task Status is "Complete"
Row Headers below: -
Status ($F$6:$F$45)
Task Owner ($K$6:$K$45)
Actual Estimate ($M$6:$M$45)
The idea being, I choose who is allocated the task (Column K), fill in the estimated time for that task (Column M), and it then adds up the total effort for that individual, but I need it to exclude the row from the count when the "Status" (Column F) reads "Complete"
Below is where I plan to summarise each persons total effort, and the initial formula I used to search for the person and to the adding up.
=SUMIF($K$6:$K$45,"*Name of user assigned task*",$M$6:$M$45)
Hoping you can help,
Thanks
Bazola