How do I find if any numbers from a set add up to a given total?

  • Thread starter Thread starter Uda Quai
  • Start date Start date
U

Uda Quai

I'm trying to find a function or formula for the following: I have a set of
10-20 numbers and a given total. I need to figure out if any combination(s)
of numbers from the set will add up to that total.

For example: Given the numbers 752, 834, 916, 705, 969, 809, 1429, 8, 63,
5127, 813, 42, 7, 1152 and 89, are there any combination(s) of these that
will total 3239? If yes, which numbers?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I determine which data in a range add up to a fixed number? 5
function to find which cells add up to a given total? 6
Find terms that sum to chosen total among a column of numbers? 2
how to find a special total from a combination of numbers 4
How to ID numbers in Excel sheet that add up to specific sum? 1
Find numbers in a range that sum up to a specified number 6
Find the combination of numbers that when added equal a reqired total?? 5
HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL 4

Back
Top