Rank results in two diffrent blocks

Hi

I am trying to Rank results in 2 blocks both have totals at the bottom of the block.

See block below Can anyone please help me on how to rank this ignoring the totals at the bottom.

Many thanks


Total

£52,482
£9,261
£10,972
£37,574
£37,269
£30,354
£19,416
£27,875
£50,962
£28,351
£24,499
£38,324
£28,836
£20,443
£50,214
£33,146
£11,847
£18,135
£12,293
£67,011
£16,432
£19,912
£19,949

£665,556


£5,492
£19,088
£10,252
£20,808
£14,771
£26,729
£37,058
£3,732
£31,900
£26,613
£13,591
£29,025
£22,104
£8,613
£25,825
£23,710
£27,561
£27,274
£26,863
£26,543
£13,882
£51,220
£27,731
£34,307
£26,358
£11,074
£41,296

£633,418

Any help please fellows

Thanks a lot for your help on this

Much appreciated