Determine which cells from a specific range equal a certain sum
 

We have a list of 12 figures and a list of 3 totals. We need to find what
combination of figures from the list of 12 equals each of the three totals.
Is there a specific function or formula that can be used to determine which
figures will equal the specified number?

Maxter,

If you reply to me privately, I will send you a workbook that can do this, at least one total at a
time. When you reply to me, take out the spaces and change the dot to .

HTH,
Bernie
MS Excel MVP


"Maxter21" wrote in message
...
We have a list of 12 figures and a list of 3 totals. We need to find what
combination of figures from the list of 12 equals each of the three totals.
Is there a specific function or formula that can be used to determine which
figures will equal the specified number?