Find multiple criteria and return sum of values

Hi

I am trying to look up multiple criteria and return the sum of values next to them. Not sure if this can be achieved with INDEX MATCH or another formula.

I have attached an example.

My sheet has a number of tables relating to various teams and the venues they have played at in the past. When the next game comes up, I need to check how many games they have played at each venue and return that total. If it is mid way through the season, I also need to include these (see example attached).

If anyone can assist, that would be really appreciated