Formulas to find a sum of numbers

[Guest]

Don’t know if it is possible to do this or not. I am trying to find out if
there is a way to use a formula to locate a sum of numbers. For instance, you
have a column with dollar figures in it and you want to find a group of those
values that total a certain amount. Is this doable?

 

[Frank Kabel]

Hi
depends on the number of values and if they also contain negative
numbers. For lets say

40 numbers (including negative ones) not possible as you have to

calculate too many combinations if you want ALL possible matches

 

[Guest]

No neg numbers but sometimes more than 40. I could break it into groups of 40
if need be. So what formula are you thinking about?

 

[Frank Kabel]

Hi
there's no formula and if you want all possible sums it just would take
too much time to scann all possible combinations (we're talking
days/weeks for the calculation)

 

[Guest]

I have already spent days with no luck in manualy looking for a figure match.
Oh well.

Jim