Ask Experts Questions for FREE Help !
Ask

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

Asked Mar 9, 2012, 03:35 PM — 1 Answer
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

Search this Thread
Share |
1 Answer
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#2

Mar 13, 2012, 09: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.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



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

View more Spreadsheets questions Search