Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to match the sum of a list of 24 different values to a specific value.
How do I write a formula calculating all possible values form the given list? A combination of the sum of the list should add up to 44,007.31 The data list is as follows: 483.34 758.06 852.67 1,494.61 1,806.25 1,842.28 2,070.88 2,130.14 2,913.33 3,946.90 3,957.38 4,154.26 4,504.18 4,831.08 5,083.52 5,092.55 5,121.39 5,824.48 6,361.67 6,835.00 6,875.09 6,898.54 8,662.80 10,854.69 Your input would be highly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching Values | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
Count items between specific hours on a matching date | Excel Worksheet Functions | |||
Searching and matching the textvalues in specific column ranges | Excel Programming |