Sumifs, vertical and horizontal

[Tella0028]

[TABLE="width: 500"]
<tbody>[TR]
[TD]KKS[/TD]
[TD]Application[/TD]
[TD]Actual[/TD]
[TD]Before 6 Feb 2017[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Rings[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Lagging 1st Layer[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Lagging 2nd Layer[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Before 6 Feb 2017[/TD]
[TD]Before 6 Feb 2017[/TD]
[TD]Before 6 Feb 2017[/TD]
[/TR]
[TR]
[TD]KKS Code[/TD]
[TD]Rings[/TD]
[TD]Lagging 1st Layer[/TD]
[TD]Lagging 2nd Layer[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]KKS[/TD]
[TD]Application[/TD]
[TD]Actual[/TD]
[TD]Before 6 Feb 2017[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Rings[/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Lagging 1st Layer[/TD]
[TD][/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]0 0EGA[/TD]
[TD]Lagging 2nd Layer[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[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) ?