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

  • Thread starter Thread starter Daniel Roth
  • Start date Start date
D

Daniel Roth

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.
 
Back
Top