Using vlookup and sumif in Google Sheets to sum values in multiple rows meeting the criteria given

JacobH

New Member
Joined
Mar 17, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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!


NCAAT Individual.png


NCAAT Team.png
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,223,353
Messages
6,171,604
Members
452,411
Latest member
sprichwort

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top