Football Data Analysis – Optimisation

I have created a spreadsheet which analyses historical football data to find set criteria for upcoming football fixtures.The criteria are as follows:
No 0 – 0 scorelines for the last 10 games for either team
Last 5 games for both teams average at least 2 goals per game

The spreadsheet functions like this:
You paste your list of fixtures into the ‘Games’ sheet.
The ‘Database’ sheet then picks out all previous game for both teams using the IF statements spanning all the way down the page.
The games are then analysed on the ‘Tables’ sheet using the IF statements spanning down the page.
If a game in the ‘Games’ sheet meets both the criteria then it will show “Yes” next to it in the list.

The spreadsheet does perform as I wanted it to, the problem is that it is extremely inefficient and it takes along time to recalculate. Can anybody take a look and advise how it could be improved to increase efficiency?

I have uploaded this to dropbox as the filesize was too large to upload on here, thanks in advance for any input!

https://www.dropbox.com/s/o4l799dpsdqgpoy/FBD.xlsm

Thanks for the response Nathan, not familiar at all with this function are you able to briefly talk me through what you have done there? Also the formula in H2 is equating to #NUM!

Thanks for the explanation (although a lot of that went over my head )

I'm just a bit confused as well with relation to the layout, you have two columns 'Team 1' 'Team 2' and then a,b,c in the rows below. What do the a,b,c relate to?