# Combinations of numbers to equal one total

1. ## 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. ## Re: Combinations of numbers to equal one total

Good afternoon Sunnangel

...and welcome to the forum!!
Originally Posted by Sunnangel
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. ## 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!

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

#### 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