Results 1 to 3 of 3

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

  1. #1
    Neophyte branconfused's Avatar
    Join Date
    Aug 2018
    Location
    Calgary, AB
    Posts
    2
    Articles
    0
    Excel Version
    Microsoft Office Pro 2016

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.41 33075 3808.88 40469.63
    8471.4 38354.21 1218 4358.55 76699.36
    37578 3675 1368.47 49.35 5853.75
    23079 6562.51 11838.77 30517.73 895.13
    10084.3 8290.95 5139.8 2590.88 26.1
    15686.55 6205.55 7062.65 2007.61 21897.2
    28307.09 10459.22 554.81 588 19027.06
    1046.64 28161 53494.88 6745.82 35356.13
    10531.5 2334.68 28664.47 19691.91 2469.25
    28521.67 945 34599.16 199023.84 3274.95
    3171 21695 170415.83 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.54 4593.75

  2. #2
    Seeker jono's Avatar
    Join Date
    Dec 2015
    Posts
    12
    Articles
    0
    Excel Version
    2016
    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. #3
    Neophyte branconfused's Avatar
    Join Date
    Aug 2018
    Location
    Calgary, AB
    Posts
    2
    Articles
    0
    Excel Version
    Microsoft Office Pro 2016
    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!!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •