Sum with multiple criteria - formula help

[PivotMeThis]

My report contains data for employees working on projects for each pay period for the past several years. I need to sum the labor hours (column M) for each employee (column H) on each project (column I) for each year (column S).

I need the total on the first row.

I've used countif/sumif in the past but there is just too many items for me to figure this out.

example (I use this formula in a different report): if(countif(k$2:k2,k2)>1,"",sumif(k:k,k2,m:m)) I thought it might be a starting point but I'm totally lost.

I really appreciate your help.
Thanks

 

[MARZIOTULLIO]

Can you provide some sample data and what the expected outcome is?

 

[PivotMeThis]

Will this do? Or do I need to do something else?



[table="width: 500"]
[tr]
[td]Employee Name[/td]
[td]Project Number[/td]
[td]Hours[/td]
[td]Year[/td]
[td]Hours/Project/Year[/td]
[/tr]
[tr]
[td]DANIEL[/td]
[td]BG-9A10(035)[/td]
[td]2.5[/td]
[td]2016[/td]
[td]20.5[/td]
[/tr]
[tr]
[td]DANIEL[/td]
[td]BG-9A10(035)[/td]
[td]18.0[/td]
[td]2016[/td]
[td][/td]
[/tr]
[tr]
[td]DANIEL[/td]
[td]BG-9A10(035)[/td]
[td]6.0[/td]
[td]2015[/td]
[td]6.0[/td]
[/tr]
[tr]
[td]BURKE[/td]
[td]BG-9A10(035)[/td]
[td]34.0[/td]
[td]2016[/td]
[td]105.0[/td]
[/tr]
[tr]
[td]BURKE[/td]
[td]BG-9A10(035)[/td]
[td]71[/td]
[td]2016[/td]
[td][/td]
[/tr]
[tr]
[td]BURKE[/td]
[td]BG-9A10(035)[/td]
[td]43.0[/td]
[td]2015[/td]
[td]67.0[/td]
[/tr]
[tr]
[td]BURKE[/td]
[td]BG-9A10(035)[/td]
[td]24[/td]
[td]2015[/td]
[td][/td]
[/tr]
[tr]
[td]JOHNSON[/td]
[td]BRF-006-4(159)[/td]
[td]75.0[/td]
[td]2016[/td]
[td]75.0[/td]
[/tr]
[tr]
[td]JOHNSON[/td]
[td]BRF-006-4(159)[/td]
[td]76.5[/td]
[td]2015[/td]
[td]136.5[/td]
[/tr]
[tr]
[td]JOHNSON[/td]
[td]BRF-006-4(159)[/td]
[td]60.0[/td]
[td]2015[/td]
[td][/td]
[/tr]
[tr]
[td]JOHN[/td]
[td]BRF-006-4(159)[/td]
[td]15.8[/td]
[td]2016[/td]
[td]25.9[/td]
[/tr]
[tr]
[td]JOHN[/td]
[td]BRF-006-4(159)[/td]
[td]10.1[/td]
[td]2016[/td]
[td][/td]
[/tr]

[/table]

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Employee Name[/TD]
[TD]Project Number[/TD]
[TD]Hours[/TD]
[TD]Year[/TD]
[TD]Hours/Project/Year[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]DANIEL[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

2.5​

[/TD]
[TD]

2016​

[/TD]
[TD]

20.5​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]DANIEL[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

18​

[/TD]
[TD]

2016​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]DANIEL[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

6​

[/TD]
[TD]

2015​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]BURKE[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

34​

[/TD]
[TD]

2016​

[/TD]
[TD]

105​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]BURKE[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

71​

[/TD]
[TD]

2016​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]BURKE[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

43​

[/TD]
[TD]

2015​

[/TD]
[TD]

67​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]BURKE[/TD]
[TD]BG-9A10(035)[/TD]
[TD]

24​

[/TD]
[TD]

2015​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]JOHNSON[/TD]
[TD]BRF-006-4(159)[/TD]
[TD]

75​

[/TD]
[TD]

2016​

[/TD]
[TD]

75​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]JOHNSON[/TD]
[TD]BRF-006-4(159)[/TD]
[TD]

76.5​

[/TD]
[TD]

2015​

[/TD]
[TD]

136.5​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]JOHNSON[/TD]
[TD]BRF-006-4(159)[/TD]
[TD]

60​

[/TD]
[TD]

2015​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]JOHN[/TD]
[TD]BRF-006-4(159)[/TD]
[TD]

15.8​

[/TD]
[TD]

2016​

[/TD]
[TD]

25.9​

[/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]JOHN[/TD]
[TD]BRF-006-4(159)[/TD]
[TD]

10.1​

[/TD]
[TD]

2016​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


E2=IF(COUNTIFS($A$2:A2,$A2,$D$2:$D2,$D2)=1,SUMIFS($C$2:$C$13,$A$2:$A$13,$A2,$B$2:$B$13,$B2,$D$2:$D$13,$D2),"") copy down

 

[PivotMeThis]

Thank you so much!