+ Reply to Thread
Results 1 to 3 of 3

Combinations of numbers to equal one total

  1. #1
    Registered User
    Join Date
    04-09-2009
    Location
    Waterloo, ON, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combinations of numbers to equal one total

    Hello gurus!

    Here's my question...I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount.
    e.g.
    List of Numbers
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    Amount to be reached = 12

    These are some of the possible combinations to reach 12 :
    2+10
    3+9
    4+8
    5+7
    3+4+5
    6+3+2+1

    Is there a function in Excel that will do this for me? I want to know which numbers (i.e. cells) can be added to reach 12. AND, if possible, colorcode the cells added for each combination.

    Good luck and thanks!!

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,291

    Smile Re: Combinations of numbers to equal one total

    Good afternoon Sunnangel

    ...and welcome to the forum!!
    Quote Originally Posted by Sunnangel View Post
    I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount.
    Is this recent discussion thread of any use to you?

    HTH

    DominicB

  3. #3
    Registered User
    Join Date
    04-09-2009
    Location
    Waterloo, ON, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Combinations of numbers to equal one total

    Yikes! I had no idea it was that involved....I guess I'll just do it the old fashioned way and guess! Thanks for your help DominicB!

    P.S. Since this seems like a useful tool, you'd think the Excel creators would incorporate it into the available functions within Excel!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1