On one page I have 5 columns of names. These are 5 person combinations from a group of 17 people, so there are 6,188 combinations listed.
On a different sheet, I have these 17 different names listed across the top, and at the end in the column to the right I have a column titled minutes. Each row under the header row (where the 17 names and "Minutes" is labeled) has an "x" in five spots depending on what person was used, and then a number in the minutes column depending on how long they were used for.
What I want is to be able to Sum the amount of minutes each combination of names was used for on the page where I have listed all the combinations.
Any help would be greatly appreciated.
On a different sheet, I have these 17 different names listed across the top, and at the end in the column to the right I have a column titled minutes. Each row under the header row (where the 17 names and "Minutes" is labeled) has an "x" in five spots depending on what person was used, and then a number in the minutes column depending on how long they were used for.
What I want is to be able to Sum the amount of minutes each combination of names was used for on the page where I have listed all the combinations.
Any help would be greatly appreciated.