How to add up costs per resource per milestone for a report
 

I have a task list in Excel that has rows that look like this:
Task Person Milestone Time

Each person could have multiple tasks in a given milestone.

Now I want to produce a report in Excel that shows how time each person is
spending working on the project for a given milestone. How do I calculate
this using Excel? I haven't been able to find any function that lets me get
all of the tasks that are assigned to specific person, or get al of the tasks
in a particular milestone.

Thanks for the help.

How to add up costs per resource per milestone for a report
 

Nevermind, I figured this out. SUMIFS is my friend.

"Daniel Roth" wrote:

I have a task list in Excel that has rows that look like this:
Task Person Milestone Time

Each person could have multiple tasks in a given milestone.

Now I want to produce a report in Excel that shows how time each person is
spending working on the project for a given milestone. How do I calculate
this using Excel? I haven't been able to find any function that lets me get
all of the tasks that are assigned to specific person, or get al of the tasks
in a particular milestone.

Thanks for the help.