20 different numbers want excel to determine which combo add to x

[OCDN-IT]

I would like to have excel look at an array of numbers and determine which
ones add to a particular sum

 

[Gary''s Student]

See:

http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[iliace]

I would like to have excel look at an array of numbers and determine which
ones add to a particular sum

Just discussed this:

http://groups.google.com/group/micr...hread/61a0a92a07c8c414/d483eb205d2d987b?hl=en

There's some VBA code that does this quite well.