VLOOKUP - AVERAGE on Imported XML data

So, heres the deal, i imported several data from a XML.

That data contains sold volume of specific items on a 15 day period.

as you can see here


version currentTime name key typeID regionID date LowPrice highPrice avgPrice volume orders
2 2013-06-13 20:54:47 history 438 10000002 5/30/2013 1106060.91 1247994.77 1247994.66 2999 459
2 2013-06-13 20:54:47 history 438 10000002 5/31/2013 1247994.66 1247994.7 1247994.68 1684 426
2 2013-06-13 20:54:47 history 438 10000002 6/1/2013 1247995 1250000 1249999.94 1096 428
2 2013-06-13 20:54:47 history 438 10000002 6/2/2013 1274099.88 1275000 1274999.99 418 192
2 2013-06-13 20:54:47 history 438 10000002 6/3/2013 1275000 1429973.53 1429973.46 621 296
2 2013-06-13 20:54:47 history 438 10000002 6/4/2013 1275943.89 1429972.68 1429972.64 905 404
2 2013-06-13 20:54:47 history 438 10000002 6/5/2013 1422995.91 1422999.99 1422996.92 1300 508
2 2013-06-13 20:54:47 history 438 10000002 6/6/2013 1320000 1422990.35 1421988.35 2194 608
2 2013-06-13 20:54:47 history 438 10000002 6/7/2013 1350022.94 1400022.98 1400019.95 1296 545
2 2013-06-13 20:54:47 history 438 10000002 6/8/2013 1349996.92 1400019.8 1400019.58 1989 560
2 2013-06-13 20:54:47 history 438 10000002 6/9/2013 1394999.89 1400019.54 1398999.98 2063 631
2 2013-06-13 20:54:47 history 438 10000002 6/10/2013 1333334 1394997.8 1394995.58 2929 499
2 2013-06-13 20:54:47 history 438 10000002 6/11/2013 1394991.98 1394995.52 1394993 1840 507
2 2013-06-13 20:54:47 history 438 10000002 6/12/2013 1393999 1393999.99 1393999.96 1040 388
2 2013-06-13 20:54:47 history 440 10000002 5/30/2013 1650010.24 1809998.8 1804989.58 778 271
2 2013-06-13 20:54:47 history 440 10000002 5/31/2013 1803984.57 1804985.03 1803984.73 969 235
2 2013-06-13 20:54:47 history 440 10000002 6/1/2013 1650021.36 1803948.48 1802998.78 1213 307
2 2013-06-13 20:54:47 history 440 10000002 6/2/2013 1802999 1803948.43 1802999.92 437 135
2 2013-06-13 20:54:47 history 440 10000002 6/3/2013 1802000 1803917.98 1803917.92 486 207


Each XML Imported has at least 15 different items, they way i can recognized them is by his TypeID

Right next to the this table i got an =AVERAGE function will calculate the average sold volumen for the past 15 days like these: =AVERAGE(A10:A20)

On my main Tab, i can make a =Data!A2

Thing is i would love to get a Vlookup+Average function to work without doing the average manually on each TypeID.

Is there any way to simplify this?.

Heres the File.

This was way better on Google Docs thanks to the ImportXML function, sadly they have a 50 ImportXML limit

Just found out a "solution" or at least seems working.

=AVERAGEIF(Data!$F$3:$F$216,Sheet1!$A2,Data!$L$3:$L$216)