Excel 2007 : Conditional Calculations

Hi Folks,

Here's what I'm trying to do.

I'm trying to get a weighted average for a series of numbers, but if certain numbers in a column A are errors or negative numbers, I want to ignore them and still maintain the weighting. Check the data for clarification

I have to do this for a large series of numbers, which is why an conditional statement would be easier.