Determine which cells from a specific range equal a certain sum

[Maxter21]

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?

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?