As an Esports coach at our school, I like to keep track of all of our stats and scores, so of course I use a Google Sheet to do that. Now I could simply use a basic sheet but that is no fun. Instead I have a sheet that uses a combination of equations (Sum, Countif, IF) along with Conditional Formatting in order to create a score sheet that is so much better.

You can make your own copy of the Score Sheet and if you just wanted to use it to score your own games, then just make a copy of that sheet and then make a copy of the Sheet1 tab in order to have a new score sheet for each match, but then do not edit any cell with an equation in it. If you want to play around with how this works, you can easily make duplicates of the main tab and play until you fully understand how the equations work.

Watch the following video to see how this sheet works and how you can use some of those basic equations and tools to make a much better sheet. Remember you