Hi All,

Couldn't find this on google or on the forums so I was hoping someone in this forum could help with some input.

I have 2 columns:
1) A unique identifier
2) Value

There are two basic rules I'm trying to follow:
1) Three items must be added to equal a minimum of 4200
2) No item can be used more than once (both in the set of 3, and the total sheet)

The goal in this scenario is to create some sort of optimization formula/macro or excel solver that will allow me to see the greatest amount of combinations (of three unique items) that can be created from this dataset. I've created 3 scenarios in the attachment, but they are all manual processes and I'm not sure if they have the greatest optimization. I'm trying to create an automated process as the values in this dataset will be constantly changing and growing, which means a manual process will be tedious.

Would much appreciate if anyone has ideas!

Thanks!Excel Sum Help.xlsx