# Thread: How to solve for multiple numbers that add up to X from a list??

1. ## How to solve for multiple numbers that add up to X from a list??

I have a list of 78 numbers and 5 of those numbers add up to X but there is no indication as to which ones. How do i create a formula to find which set of 5 numbers adds up to my X exactly?

Out of this list - what numbers add up to 202223.29 exactly?? (these numbers are part of a bank statement which for some reason split the total but gave no indication which numbers were used)
 4897.05 8339.63 170.1 388.83 16427.25 55.13 18446.4 33075 3808.88 40469.63 8471.4 38354.2 1218 4358.55 76699.36 37578 3675 1368.47 49.35 5853.75 23079 6562.51 11838.8 30517.73 895.13 10084.3 8290.95 5139.8 2590.88 26.1 15686.5 6205.55 7062.65 2007.61 21897.2 28307.1 10459.2 554.81 588 19027.06 1046.64 28161 53494.9 6745.82 35356.13 10531.5 2334.68 28664.5 19691.91 2469.25 28521.7 945 34599.2 199023.84 3274.95 3171 21695 170416 9940.89 4303.95 9028.48 672 141.75 17364.91 12920.28 1134 6510.17 3628.8 235.2 4865.46 9955.73 5059.59 1050 14988.39 9855 8979.97 96382.5 4593.75

2. I was able to use Excel Solver (I've never used it before) and I was able to find 12 numbers that sum to your total, not 5??

3. I was able to use Excel Solver (I've never used it before) and I was able to find 12 numbers that sum to your total, not 5??

Yeah i did get it to work - you have to set a 4th constraint - put 5 in a cell and then the constraint is equal to that cell and then it will count only 5 numbers that add up to the total!!