Is there a function/formula for this?

O

outlet321

I have a long column of numbers. I would like to know which of these numbers
will sum to a target number. I don't know how many of the numbers are in the
sum. Here is an example to better illustrate my question:
Column A
12
73.29
45.33
94.31
34.22
18
23.44

I want to know what combination of these numbers will give me the sum of the
target number 148.62. Is there a formula or function that can do this?
 
F

Frank Kabel

Hi
do you need only one combination or all possible combinations. The
altter one is for a 'long' column not feasible

--
Regards
Frank Kabel
Frankfurt, Germany

outlet321 said:
I have a long column of numbers. I would like to know which of these numbers
will sum to a target number. I don't know how many of the numbers are in the
sum. Here is an example to better illustrate my question:
Column A
12
73.29
45.33
94.31
34.22
18
23.44

I want to know what combination of these numbers will give me the sum of the
target number 148.62. Is there a formula or function that can do
Click to expand...
this?
 
B

Bernie Deitrick

I have a sample workbook that I can send you if you contact me privately.
Take out the spaces and change dot to .

For your example, these add up to your target:

12
73.29
45.33
18

HTH,
Bernie
MS Excel MVP
 
Top