Speed up a 100k AverageIf formulas

Hi,

I have this file in which I want to use the averageifs formula to process some raw data (sheets 1 and 2).

The thing is, with over 100k calculations to do, it takes literally AGES to process all the data (somewhere between 1h-2h), and I need a way to speed things up, maybe through VBA. Any ideas on how to accomplish this? I read somewhere that using arrays in VBA is a much quicker process than using only Excel, but I don't know if this is the case.

Can you help?

Thanks

PS: I've attached a sample file with 200 rows, in which I created a macro to count the time it takes to make all those calculations. On my PC it takes little over than 2 seconds. The problem is that having 9000 rows doesn't take 2 * 9000 / 200 seconds...