Counting number of hours per project per team
 

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

Counting number of hours per project per team
 

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

"The Fool on the Hill" wrote in
message ...
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

Counting number of hours per project per team
 

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

On Dec 29, 11:14*am, The Fool on the Hill
wrote:
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

Counting number of hours per project per team
 

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.

"Pete_UK" wrote:

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

On Dec 29, 11:14 am, The Fool on the Hill
wrote:
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