Rate Card - Horizontal items - 2 rate card costs

[sward1001]

[TABLE="width: 500"]
<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]PRODUCT
[/TD]
[TD]Q1
[/TD]
[TD]Q2
[/TD]
[TD]Q3
[/TD]
[TD]TOTAL
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]VOLUMES - SUPPLIER 1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]60
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]VOLUMES - SUPPLIER 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD](On separate worksheet)
[/TD]
[TD]SUPPLIER 1
[/TD]
[TD]SUPPLIER 2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Q1
[/TD]
[TD]50
[/TD]
[TD]45
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Q2
[/TD]
[TD]5
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Q3
[/TD]
[TD]15
[/TD]
[TD]25
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi - can anyone assist, what formula would give me the totals by referencing the product costs from 2 suppliers to get a total ? eg E2 = 1*50 + 2*5

I have done something similar years ago but cant remember - was it an array function?

Many Thanks in advance.

 

[sward1001]

To add to this the worksheet contains 50 + products and rates..

thanks

 

[sward1001]

anyone?