| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
| Sorting a range of cells that get value from other cells | Excel Discussion (Misc queries) | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Linear Mode
