Interesting question

You could do this by using the DEC2BIN function to generate all of the
binary numbers up to two to the power of the count of the numbers that
you have. The individual places could then be used as switches for
whether each number is included in the sum or not. This would allow you
to evaluate all possible combinations and therefore see which matches
your target.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=540388