the only way to do that is use VBA and think of an algoritm to solve
your
sum.

If you want to calculate all possebility's don't be surprised to wait
for several years before it would have the best solution if there is
any.

it's an exploding situation

with three numbers there are 8 possebility's
with four , 16
with five , 32
with six , 64
7...128
8...256
9...512
10..1024

16.. 65532

32.. 42949766

with hundred.... 2 to the power of hundred!


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=466382