I'm building a massive Win-Loss table among several hundred teams and individual matchups. And I need to have a total win/loss summary after all is said and done. The way I have it set up, for example is

<-----------------Team 1----------------------->
Team, Total Wins, "-" separator, Total Losses, Wins vs. Team 1, "-" separator, Losses vs. Team 1,

And then the final 3 columns are repeated over and over for Teams 2 through xx. Is there a way to solve for the total wins/losses in B/D columns without clicking each individual win box? In other words, can I create a formula that only adds every 3rd box?

Thanks in advance for any help :)

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure you demonstrate your desired results, mock it up manually based on your example data.