| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting hours spent by a team per project
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 !! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting hours spent by a team per project
Change the "project ID" and "team" to whatever it is. If numerics you dont
need double quotes around project id. =SUMPRODUCT(--(C1:C100="projectid"),--(H1:H100="team"),J1:J100) If this post helps click Yes --------------- Jacob Skaria "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 !! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting hours spent by a team per project
Hi
=SUMPRODUCT(($C$2:$C$100="project")*($H$2:$H$100=" team ID")*$I$2:$I$100) assuming you have headers in row 1 and your data starts in row 2. Adjust ranges to suit your data, and substitute the relevant data for "team ID" and "project" -- Regards Roger Govier "The Fool on the Hill" wrote in message ... 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 !! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of hours per project per team | Excel Discussion (Misc queries) | |||
| Calculating hours spent per team | Excel Discussion (Misc queries) | |||
| Creating a formula to display # of work hours spent on a project | Excel Discussion (Misc queries) | |||
| Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Linear Mode
