View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Find Cells that add up to Specific Sum

BeachLover wrote:
I have a list of about 30 numbers in individuals cells in a column that added
up to over 200,000. I need to find the numbers within the 30 numbers that
add up specifically to 109,484.60. What formula can I use?


No mere formula can accomplish this. If you read up on /combinations/, e.g.,

http://tutors4you.com/permutationcom...ontutorial.htm

You will find the number of combinations of values you need to test is

2^30 - 1 = 1,073,741,824

That's over 1 /billion/ combinations! You need code that can loop
through all the possibilities.

The link posted by Gord Dibben might help. Good Luck!