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? |
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) |