Weighted Average Summary Table

I need to calculated the weighted average for each item in a worksheet (columns A:E in the attached file). I have created a summary table to identify each item (columns G:H). The formula in cell H4 does not work.

How do you join an if statement with the SumProduct function?

Thanks in advance for your assistance.

Try:

=SUMPRODUCT(--($A$4:$A17=$G4),$D$4:$D$17,$E$4:$E$17)/SUMIF($A$4:$A$17,G4,$D$4:$D$17)

copied down