if given 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and I need to find out


But if the given sum is in the same magnitude as the 130 numbers there
will only be very few of them included in the sum.


Hi. If interested:
If given the integer numbers 1,2,...130, then there are
4,654,670 combinations that total 130, and
486,796,713 that total 200.

The maximum count occurs at
130*((1 + 130)/4) = 4257.5 (ie two of them)

The total number of combinations that total 4,257 and 4,258 a
1,257,431,811,792,459,815,722,395,070,685,090,292

--
HTH :)
Dana DeLouis


"Lars-Åke Aspelin" wrote in message ...

On Mon, 28 Jul 2008 14:02:40 -0700, frank
wrote:


I have been given 130 numbers and I need to find out which of them can be
added up to a given number.
for example, if given 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and i need to find out
which of them adds up to 33.
is there anything excel can do?
pls help


More information please.

What kind of numbers are we talking about here?
Real numbers? Integers? Positive?
What is the given number?
If the given sum is a big number, compared to the given numbers, there
will be very many combinations to test.
But if the given sum is in the same magnitude as the 130 numbers there
will only be very few of them included in the sum.

Lars-Åke