Solver Problem with Range

[JStellato]

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]Maximum[/TD]
[TD]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Min
[/TD]
[TD]Max
[/TD]
[TD]Value
[/TD]
[TD][/TD]
[TD]Best Combination
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]14[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]14-15[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]15[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]14-15[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]16[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]17[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have a problem that I think Excel Solver can help me with, but I'm not certain. What I want to do is determine the best combination given a maximum number. However in all the examples I've found, the product usually is a single item, rather than a range. In this case I need to know the best combination with the understanding that each product has a range, but an overall maximum acceptable value.

In this example I obviously just created the answer by hand to demonstrate that although the maximum was 29 because those two product fall within the range, that is the maximized value of 2 x 50 = 100.

Does anyone know how I can use excel to determine this solution?