Hopefully this makes sense.
I have built a sheet with a round robin soccer tournament schedule. In column B is the name of each team followed by column C with goals scored column D is the second team name followed by column E which is goals scored by the second team.
There are 10 teams in total so there are five entries for each round of the tournament.
On the sheet I have separated each round by one space and each round has a heading of team name, goals for, team name, goals for. This results in the team names being separated by blank rows and by rows with those headers in them.
I'm trying to figure out if there is a way to make a second sheet with a table that will look up each team's name and then some the entire total of goals for the entire tournament regardless of where the team name exists. For example the Wildcats team name might exist three times and column A and six times in column C. I need the totals from columns B&D based on where their name exists.
I have built a sheet with a round robin soccer tournament schedule. In column B is the name of each team followed by column C with goals scored column D is the second team name followed by column E which is goals scored by the second team.
There are 10 teams in total so there are five entries for each round of the tournament.
On the sheet I have separated each round by one space and each round has a heading of team name, goals for, team name, goals for. This results in the team names being separated by blank rows and by rows with those headers in them.
I'm trying to figure out if there is a way to make a second sheet with a table that will look up each team's name and then some the entire total of goals for the entire tournament regardless of where the team name exists. For example the Wildcats team name might exist three times and column A and six times in column C. I need the totals from columns B&D based on where their name exists.