Thank you! SumIf is great for sorting data by team number in my experience.
We did most of our decision making out of tableau, and that's where we have pages to directly compare teams. You can check those out on
my new thread, I'm hoping to consolidate conversation there.
Depending on future games, a lookup page may be something I suggest to students, thank you for your input