Determine which cells from a specific range equal a certain sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top