Sumifs, vertical and horizontal

[Tella0028]

KKS	Application	Actual	Before 6 Feb 2017
0 0EGA	Rings
0 0EGA	Lagging 1st Layer
0 0EGA	Lagging 2nd Layer

<tbody>
</tbody>

	Before 6 Feb 2017	Before 6 Feb 2017	Before 6 Feb 2017
KKS Code	Rings	Lagging 1st Layer	Lagging 2nd Layer
0 0EGA	2
0 0EGA	5	9	3
0 0EGA		6

<tbody>
</tbody>

The top is the info I have available, I need to get the below result with a formula, there is +- 5000 lines so doing is manually is not an option.

KKS	Application	Actual	Before 6 Feb 2017
0 0EGA	Rings		7
0 0EGA	Lagging 1st Layer		15
0 0EGA	Lagging 2nd Layer		3

<tbody>
</tbody>

 

[Special-K99]

So there are only 3 columns on the second sheet headed "Before 6 Feb 2017" (since you've only presented three and not said otherwise) ?