Counting hours spent by a team per project

[The Fool on the Hill]

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 !!

 

[Jacob Skaria]

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]

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

 

[Roger Govier]

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"

 

[Roger Govier]

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"

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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