I have a series of numbers (1,2,4,5,6,7,9,11,13,14,15,16). Is there a
formula or way that gives me the result of any two numbers (or any 3 numbers
or 4, etc.) that totals to 20. For example, 9 + 11=20; 2 + 5 + 13 =20; 1 +
2+ 4 + 13= 20; as well as 7+13=20 so on.

Will scenarios in Excel 2007 do this? I poked around with SUMIF but the
difficulty is that you have different cells that can add up to 20 and I don't
know how one would allow for selecting different cells. I looked briefly at
conditional formatting but again you run into the problem of the varied cells
that can add up to 20. I also looked at arrays but did not see anything
there that allows different elements in the array to be added in such a way
as to equal 20 and then identifying which elements were used. I also
investigated lookup with arrays and that, too, does not address my need -- at
least, based on how I have used them in the past.