Not sure if this it better suited for macro or formula but this is my question:

I have a summary table that I want to pull a weighted average from matching criteria in the data table. What would be the easiest way to do this?

Further info**
Lets say I want the weighted average for bonus points(col D,SUMPRODUCT) by balance (col C, SUMPRODUCT) for everything that falls in between 2 and 2.5 (col B,IF)

My formula doesn't work =IF(AND(B:B>2,B:B=<2.5),SUMPRODUCT(C:C,D:D)/SUM(C:C),0)

Thanks!