Sumproduct across ranges with varying sum values

[plasteredric]

Hi, have a difficult problem to explain. Trying to put a formula together (similar to a sumproduct formula) that multiplies each row of an array with a value that is assigned to the cell on the same row.

I've included the sample sheet as that explains it better.

Thanks
20551

[Bob Phillips]

Try this array formula

=SUM(IF($E$9:$E$14=G3,$C$9:$C$14))

[Bob Phillips]

Or even

=SUMPRODUCT(--($E$9:$E$14=G3),$C$9:$C$14)

[plasteredric]

Sorry i probably didn't explain myself very clearly. I've revised the attached sheet to show the calculation steps involved.
I would rather not have a results column next to each selection, if there is a formula I can put in the totals cells that will work it all out that would be fantastic

20553

[Bob Phillips]

If you can sort the first table into Type order, this array formula should work

=SUM(IF(G3=$E$9:$E$14,LOOKUP($F$9:$F$14,$D$3:$E$6)*$C$9:$C$14))

The array formula is entered by pressing the keyboard combination

Ctrl
+
Shift
+
Enter