Formulas to find a sum of numbers

R

ramblreb

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?
 
F

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
Click to expand...
calculate too many combinations if you want ALL possible matches
 
R

ramblreb

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?
 
F

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)
 
R

ramblreb

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

Jim
 
Top