Transferring team scores into a league table

mrall here are some suggestions to your solution:

In case of 3 solutions you don't need 3 IF functions: =IF(D5>E5;3;IF(D5<E5;0;IF(D5=E5;1)))
Not that if D5 > E5 and D5 < E5 it MUST be D5=E5, so no need to test is D5=E5. Your formula should look like:

=IF(D5>E5;3;IF(D5<E5;0;1))

Second: You don't need SUM in equations: =SUM(S4+M4) is just =S4+M4

and last, since you've already calculate Home and Away points in F and G column, no need to calculate again.. Just use SUMIF function to sum them together:

Edit: Aslo, avoid INDIRECT function when it's not necessarily since it's volatile.