Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours spent per team
Dear Excel(lent) users,
I have a challenge, which I would like to share with you: I am managing multiple projects and have multiple teams working on these projects. I want to know how much time is spent on what project by what team. Column A = Project Column B = Team (e.g. team 1, team 2, team 3, team 4) Column C = number of hours spent Can you please give me formula which gives me the desired information? Thank you kindly !! Jaydubs !! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours spent per team
On a separate sheet you could lay out a table like this:
Team1 Team2 Team3 etc Project1 Project2 Project3 etc and then in B2 you could have this formula: =SUMPRODUCT((Sheet1!$A$1:$A$100=$A2)*(Sheet1!$B$1: $B$100=B$1)*(Sheet1! $C$1:$C$100)) then copy across and down as required. You could also use a Pivot Table for this. Hope this helps. Pete On Dec 29, 11:06*am, The Fool on the Hill wrote: Dear Excel(lent) users, I have a challenge, which I would like to share with you: I am managing multiple projects and have multiple teams working on these projects. I want to know how much time is spent on what project by what team. Column A = Project Column B = Team (e.g. team 1, team 2, team 3, team 4) Column C = number of hours spent Can you please give me formula which gives me the desired information? Thank you kindly !! Jaydubs !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a formula to display # of work hours spent on a project | Excel Discussion (Misc queries) | |||
summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions |