Excel function and formula can't do this, try using the Solver solution

see this link, a solver solution provided by Peo Sjoblom

http://groups.google.co.uk/group/mic... ublic.excel.*
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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.