http://i.imgur.com/7ywwh.png

please see link above first

Here is my problem, i would like to do the following:
I have several different projects with different conditions. I have shown these conditions as old and new and a letter: A, B or C. to the right i have all the combinations: NEW A, NEW B, NEW C etc.
I want to search for the values in the "Field 1" row and pick out the ones that match the specified conditions based on them matching the conditions above each cell. e.g. i want to find all the values in Field 1 row that are NEW and A: THEN i want to get their AVERAGE.
so in real life for this i would write the formula in cell K9 and it would find & average cells B9 and H9 since they match those peramiters.
If anyone can do this i will buy them a beer.