For the NCAA Tournament, I have one sheet to keep track of each individual player's stats from every team participating and another sheet for keeping track of the team totals. I am trying to add up the values from players on the same team and get a total returned in the team sheet, which is my issue, not sure how to set up the formula with vlookup and sumif to have this work properly. I have attached a picture of each sheet to help with this. The first one is the individual stats sheet named "Individual" and the second is "Team". For example, I am trying to have all the players' minutes played (MP in column H) from Abilene Christian summed up and returned in the team sheet minutes played in column G. Any help would be greatly appreciated, thanks!