SumIf for same column value in one, and different value in another

[jojoman86]

This is my first post so I am very glad this exists. Thanks for your help in advance

Column A Column B Column C (hours) Column D
John Doe 1/5/80 50 70
John Doe 1/5/80 20 70
Jane Pear 2/8/81 10 10
Jane Pear 12/4/78 25 25
Action Jackson 5/5/90 30 80
Action Jackson 5/5/90 50 80
Pity Foo 4/3/65 15 15
Pity Foo 3/4/56 20 20

I have the above table. I want to tally up the hours of each person with a formula, but as you can there are duplicates....one with same name and birthdate, and another same name/different birthdate. What SUMIF can I use to in column D differentiate and tally the correct hours that are in column D?

Hope my question makes sense!

 

[CSmith]

something like this . . .

=SUMIFS([Hours],[Name],"="&[@[Name]],[Birthdate],"="&[@[Birthdate]])