Help with Sumif formula please

[jedibrown]

Hi all - I am having some problems with a formula.

I am trying to find a formula which picks out the relevant I.D's in the first column and produces how many hours in total it's been worked on if it's with a certain team.

The ID will appear several times in column a and will have hours for each time it appears in column D.

ID Date changed Hours With Total Time

I want a formula which says:

Look in column A (ID) for a specific ID (E.G. 444) then look in column E to see if it's with a specific team (say team A) and if it is, add up all of the hours listed in column D which correspond.

I hope this makes sense - any help will be much appreciated.

 

[jedibrown]

I have tried this and it's also not working but don't understand why

=SUMIFS(D5:D16,A5:A17,444,E5:E17,A)

 

[VoG]

Try

=SUMIFS(D5:D17,A5:A17,444,E5:E17,"A")

and format the result cell as Custom

[h]:mm

 

[jedibrown]

Thank works perfectly - thank you.

Would it also be possible for me to add 1 more column?

I also want it to add up the hours that are over a certain date so..

I want it to look for the issue ID, look for the team and add up the hours but, I also want it to look in column C for dates over say 18/02/11 and only count those.

Is this possible?

Thanks

 

[VoG]

Try

=SUMIFS(D5:D17,A5:A17,444,E5:E17,"A",C5:C17,">="&DATE(2011,2,18))

 

[jedibrown]

This works perfectly - thank you very much for your help.