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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using vlookup and sumif in Google Sheets to sum values in multiple rows meeting the criteria given
- Thread starter JacobH
- Start date
Similar threads
- Question
