Football/Soccer data, teams giving up a lead or recovering a goal deficit

yes, you're correct.
the formula in Column AT were transposed by mistake, should be =MIN(AH2:AL2)-MIN(X2:AB2), see attached.

as it stands, Column AT check which team scored first and Column AS with nett goals that should be enough to fulfill your goals (no pun intended).