Sport results and performance tracking using Excel

[ItalianPlatinum]

Hello - I run a pickup team and currently trying to find a way to have a tab where I can have all the teams I ever played against with the Wins, losses, Ties, Record and Points for historical performance. in the other tab i have all our results that I will manually input. The performance tab would be nice to populate automatically as I add a result in. Then If i play a new team i can manually add it (to avoid complexity). I tried countIF but quickly realized that isn't going to work for me. anyone have ideas to how to make this work?

Results (manually inputted)

Season​	Opponent​	Win​	Loss​	Tie​
2021 Game 1​	Team A​	X​
2021 Game 2​	Team B​		X​

Historical performance (help with automation)

Team​	Wins​	Loss​	Tie​	Record​	Points​
Team A​	1​	0​	0​	1-0-0​	3​
Team B​	0​	1​	0​	0-1-0​	0​

 

[steve the fish]

Try using these:

=COUNTIFS(Results!$B:$B,$A2,Results!C:C,"X")
=B2&"-"&C2&"-"&D2
=B2*3+D2*1

 

[ItalianPlatinum]

Thanks this seems to be working