Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating hours spent per team | Excel Discussion (Misc queries) | |||
Calculate number days + hours to complete a project | Excel Worksheet Functions | |||
Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
How to project the due date according to a number of working hours | Excel Worksheet Functions |