see:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200852


"JOSEPH WEBER" wrote:

Is there a function or formula that can calculate which numbers add up to
another. for example:

5
6
7
8

I want the combination of numbers that will give me 21. In other words I
know what the answer should be, just need to find out which combination of
numbers will give me the answer.