Head 2 Head Record

[uncle_pablo]

Hi Everyone, I've done much reading but never posted any help on this site before until now. I just cannot find help with this situation and it's probably very simple.

I have a competition whereby fixtures are played between teams and results recorded. What I would like to do is have a summary which holds a record of Wins, Draws, Losses, Goals for and Goals Against between 2 teams. So for example, I would like the summary to show those statistics for the games between Team 1 & Team 2 etc.

My data source is basic, however, the issue I have is sometimes a team is away from home, so Team 1 for example aren't always in column 1.

Here are the results, what i'd like is for it to show the head to head record for all teams.

Thanks

Home HS AS Away
Team 1 1 2 Team 2
Team 3 2 1 Team 5
Team 5 2 0 Team 2
Team 3 4 1 Team 4
Team 4 2 0 Team 2
Team 5 2 3 Team 1
Team 3 1 0 Team 2
Team 4 0 3 Team 1
Team 3 2 0 Team 1
Team 4 1 3 Team 5
Team 1 5 0 Team 2
Team 3 0 0 Team 5
Team 5 2 1 Team 2
Team 3 1 1 Team 4
Team 4 0 0 Team 2
Team 5 0 3 Team 1
Team 3 2 0 Team 2
Team 4 1 0 Team 1
Team 3 1 2 Team 1
Team 4 0 3 Team 5

[wayneg]

this is what i have had in the past... hide columns M to Z, its there just for the working out

[uncle_pablo]

Hello. Thanks for your response. This is not what I am looking for, sorry if my post isn't clear enough.

I am looking for a summary which shows every time Team 1 plays Team 2, it has their Head to Head record next to it. For example:

Team 1 v Team 2 W 2 D1 L0 GF 10 GA 4

This means Team 2's record against Team 1 will look the opposite:

Team 2 v Team 1 W0 D1 L2 GF 4 GA 10

The problem I have is that Team 1 (and the others) can appear in Column 1 or Column 4

[wayneg]

ok, will amend this sheet and repost it

[uncle_pablo]

Thank you. Any luck with this at all?

[wayneg]

hopefully this is what you asked for.

sorry for my late reply, weekend off from work

[uncle_pablo]

No problem, I hope you enjoyed your weekend.

Brilliant!! Thank you, this is exactly what I needed.

[wayneg]

just a few sumifs in the right place hope it is what you were looking for. add rep if applicable