Ranking By Group instead of full competition

[Grimace]

Good morning

I have a competition scoring system that currently ranks 20 teams in order, and is working fine.

I want to be able to break the 20 teams into 4 different pools, and rank within each pool instead of right across the whole 20 teams.

Please see attached file. I have had a go at it but am encountering some errors and cannot identify where i have gone wrong.

Any assistance would be greatly appreciated.

The outcome I am seeking is being able to rank the 5 teams in each pool (A - D) from 1st to 5th.

I have the results coming into columns A - F. I can get pool A to work for me no problem, however as soon as I try to step down to the next group of 5 teams I run into trouble. I assume it has something to do with my row referencing?

Thanks in advance

Darren