extract info from raw data based on alot of criteria

Hi,

I need some help coming up with a formula to get a certain desired result from the raw data. Since the raw data will always change I need a template of formulas so all i need to do is change the data.

The working sheet is what I have but im not so good with excel so im stumped...

Help please.. Thanks.

Excel 2010 with free PowerPivot Add-In
http://www.mediafire.com/view/2ygkngdsy30zgzu/04_03_14a.xlsx

for others
http://www.excelforum.com/excel-for...from-raw-data-based-on-list-of-criterion.html