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.
No function or formula can do this. You need to use Solver or VBA.
Here's a link to a VBA approach.
http://groups.google.com/group/micro...19858047398beb