Multi-Column Range Sums

[DHRogers]

Hello all,
I'm hoping the experts here can point me in the right direction for what I need to do

Here's the situation: I have an excel file that tracks production of multiple products by the week and it's set up essentially like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Name[/TD]
[TD]Week 1 Over[/TD]
[TD]Week 1 Under[/TD]
[TD]Week 2 Over[/TD]
[TD]Week 2 Under[/TD]
[/TR]
[TR]
[TD]Product 1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Product 2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Product 3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

What I'm trying to do is to create a formula that will give me the sum total of all the times each product has been over produced and under produced so I'd have something like the following (which I have set up on another sheet in the same workbook):

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Name[/TD]
[TD]Over[/TD]
[TD]Under[/TD]
[/TR]
[TR]
[TD]Product 1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

What I'm struggling with is the formula for this since it's a range that covers multiple columns. Is there a way to do this without writing a formula that references each individual column to be summed?

Any advice would be greatly appreciated, I've been beating my head against a wall for a couple of week trying to create a usable format.

 

[FDibbins]

Maybe this?
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][/tr]
[tr][td]

1​

[/td][td]Product Name[/td][td]Week 1 Over[/td][td]Week 1 Under[/td][td]Week 2 Over[/td][td]Week 2 Under[/td][td][/td][td]Over[/td][td]Under[/td][/tr]

[tr][td]

2​

[/td][td]Product 1[/td][td]0[/td][td]2[/td][td]1[/td][td]0[/td][td][/td][td]

1​

[/td][td]

2​

[/td][/tr]

[tr][td]

3​

[/td][td]Product 2[/td][td]1[/td][td]0[/td][td]1[/td][td]1[/td][td][/td][td]

2​

[/td][td]

1​

[/td][/tr]

[tr][td]

4​

[/td][td]Product 3[/td][td]1[/td][td]1[/td][td]2[/td][td]0[/td][td][/td][td]

3​

[/td][td]

1​

[/td][/tr]
[/table]

=SUMIFS($B2:$E2,$B$1:$E$1,"*"&G$1)
copied across and down