I am trying to use solver to find an optimal solution but I've having trouble with the constraints.

Cell F8 is the sum of cells A8:E8. (and they all currently have no values)
Cells A1:E7 all contain different numbers.
(I had a nice picture of this to post here but it was over the size limit.)

Okay, I am trying to tell solver to make F8=200, and do so by manipulating cells A8:E8, with the constraint that A8 must equal a number in the range A1:A7, B8 must equal a number in the range B1:B7, etc etc up to E8.

Anyway I have arranged it so that there is only one solution. My problem comes in assigning the constraints. There doesn't seem to be a way to make a constraint that says A8 must equal "one of the following cell references".

If there's a non-solver way to do this, I'm open to that as well.

-Simon