Counting hours spent by a team per project
On Thu, 28 May 2009 01:33:01 -0700, The Fool on the Hill
wrote:
Hello Excel(lent) users,
I want to count the hours that are spent by a particular team on a
particular project. Could you please help me ?
In Column C I have the ID of the project
In Column H I have the ID of the team
The Hours I have in Column J
Could you give me a formula to help me solve this ?
Thank you very much !!
Assuming that you will have multiple lines per team/project, you could use a
Pivot Table.
Do something like
Drag teams to Rows
Drag projects to Columns
Drag hours to the Data or Value area
--ron
|