Exclude Multiple Criteria in SumProduct Weighted Average

[rmcmicken]

I am trying to calculate a weighted average many companies. I have a list of companies that are included in this range that I would like to exclude from the weighted average calculation. Is there a way to add this range to the sumproduct formula so that the companies within this range are excluded from the weighted average calculation? An example of how the data looks is provided below.

Thanks for any help!

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 192"]
<tbody>[TR]
[TD]Company[/TD]
[TD]Value[/TD]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD]GH[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]IJ[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD]KL[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD]MN[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]OP[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD]QR[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]ST[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]UV[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD]WX[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]9000[/TD]
[/TR]
[TR]
[TD]YZ[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]7000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Companies to Exclude from Wtd. Avg. Calculation[/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IJ[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MN[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ST[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WX[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]