I have a spreadsheet for my daughter team where I show the teams in different
columns as well as their scores
Home Team, Score, Visiting Team, Score

I want to automatically calculate the Goals For and Goals Against using
thios spreadsheet. Is there a standard formula that would do this for me.

I want to calculate for ALL teams, not just hers.