conditional summation

[dmpritch82]

I am trying to get excel to sum only certain numbers in a range (one column) that is equal to or as close as i can get to a specified number. Example (trying to equal 10):

Range:
1
2
3
4
5

So I want excel to output that I need to add 2, 3, and 5 or 1, 2, 3, and 4 within this range to equal 10. Multiple sulutions are fine.

Any help is appreciated.
Thank You

 

[MiketheEngineer]

Is this the "spacer" problem....which spacers will give me a certain length??

I just put each size in a loop - so in this case you have five For-Next loops

Record each answer and pick the one you want