Establish the minimum systems to enable for the maximum value

[WillN]

Hi,

I have a number of systems that exchange information and I have the number of exchanges between each combination of two sites below in month last year. Based on last years activity, I want to achieve the maximum number of exchanges by enabling only 100 sites. I have 8000 sites so I can't do the analysis by eye as I can in the example below. Any ideas how to do this in Excel to get a list of the Site names?

e.g. If I enable:
2 Sites 1&2 = 2
2 Sites 2&3 = 4+12 = 16
2 Sites 1&4 = 23

3 Sites 1&2&3 = 2+12+4 = 18
3 Sites 1&3&4 = 23+5 = 28

4 Sites 1&2&3&4 = 23+2+12+4+5 = 46


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Site 1
[/TD]
[TD]Site 2
[/TD]
[TD]Site 3
[/TD]
[TD]Site 4
[/TD]
[/TR]
[TR]
[TD]Site 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Site 2
[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 3
[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks