football prediction league help

help is much needed for my below spreadsheet

i have generated my fixtures for the above league which is set out in round order and also then each teams fixtures listed individually

i need a way that when scores are entered in the full set of fixtures they correspond to the individual sets of fixtures to enable me to create the league table. Unless there is a way of creating the table without having to add in the scores twice as mentioned?

Also to have the spreadsheet adaptable potentially as there maybe less members or more next season



lex prem test.xlsx92.13 KB