Counting number of hours per project per team

[The Fool on the Hill]

Hello Excel(lent) users,

I am stuck with a challenge, which I wanted to share with you !

I am managing multiple projects, which are executed by multiple teams. I
want to keep track of the hours spent per team per project.

I want to get that information from the following columns:
Column A Project identification (project 1, Project 2, Project 2, etc)
Column B Name of executing team (Team 1, Team 2, Team 3, etc)
Column C Number of hours spent


The display should be in a new tab:

Project Team # of hours
PR 1 Team 1
PR 2 Team 2
PR 3 Team 3
PR 4 Team 4

Can you please help me out ?

Thank you very much for helping me out !!

Jaydubs

 

[David Biddulph]

=SUMPRODUCT((A1:A100="PR 1")*(B1:B100="Team 1")*C1:C100)

 

[Pete_UK]

I see that you have posted this after your earlier thread - please do
not multi-post. You might want to check that thread for an alternative
approach.

Pete

 

[The Fool on the Hill]

Hello David and Pete,

Thanks for your answer. I did end up using pivot table in the end.

I had problems with the community yesterday, I did not see my post back, so
I re-posted. Only today I realised that both posts did manage to get through.
Sorry for the inconvenience.