# MS EXCEL: How do I find a sum using many nonadjacent values?

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

 JBeaucaire Posts: 5,400, Reputation: 5056 Software Expert #2 Mar 13, 2012, 10:04 PM

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.

## Check out some similar questions!

Excel vba returning values from a sub [ 2 Answers ]

How do I return values from a subroutine in Excel VBA? It appears that I have to "temporarily" store a value elsewhere on the spreadsheet and recover when I return to the main part of the program. Simply the program runs and asks the user to enter data on several forms, but this data has to be...

Multiples of values in excel [ 1 Answers ]

Hi all, I'm trying to find a way of getting multiples of a value so I can use it in an IF statement. Basically I need the multiples of 60, I want to be able to say IF value is a multiple of 60 then this will happen. Is there a way to do this, I've been looking at LCMs, GCDs without any luck.

Sorting and Sum in Excel [ 2 Answers ]

I'm trying to setup an excel spreadsheet to find the total dollar amount of comps given for several different vendors all out off one mass mixed up spreadsheet. I want to search for a specific name and then get a sum of the dollar amount in the cell to the right of it, over the entire list. Any...

Filter from 2 Columns (Unique values) in Excel [ 1 Answers ]

I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143