Sports question. Finding points scored by specific team

[Esradekan]

I am working on a sport summary sheet. I need to find the points scored for a specific team and the points scored against a specific team. Each Teamgame is in a "HomeTeam" or "AwayTeam' field, with their respective opponent in the 'other' field. The teams score is in a "HomeScore" or "AwayScore"field. Can anybody help me with a formula that will 'SUM' the total of points scored for and a total of points scored against a team on a 'ladder' against any and all teams? Team names on the ladder are listed in N4:N20.

TIA
Esra >(^-^)<

 

[Esradekan]

I am working on a sport summary sheet. I need to find the points scored for a specific team and the points scored against a specific team. Each Team game is in a "HomeTeam" or "AwayTeam' field, with their respective opponent in the 'other' field. The teams score is in a "HomeScore" or "AwayScore" field. Can anybody help me with a formula that will 'SUM' the total of points scored for and a total of points scored against a team on a 'ladder'against any and all teams? Team names on the ladder are listed in N4:N20.



TIA

Esra >(^-^)<

Yes I know its not a sports question, was using an opld questionm as tem[plate,. sorry

 

[ak440031]

Please explain in detail. or simply load a sample sheet with your request