Formula to find valuce that equal a sum

[c3msmlr]

To all
I'm using Excel 2003. I have a range of values that I need to find a
combined total to a specific sum for. Example: The total amount I have is
$400 but I have a range of values in 1 column that could equal $400. I need
a formual that would show me which values they could be.

Thanks
c3msmlr

 

[dlw]

that would have to be a VB routine, I would think. How many values do you
have? The number of combinations to check for the sum would be the factorial
of it.
for example, 20 values = 20! = 2,432,902,008,176,640,000 different
combinations to check.
Someone please check my math!

 

[Gary''s Student]

You can use Solver. See:

http://www.tushar-mehta.com/excel/templates/match_values/index.html#Solver_Template

 

[Pete_UK]

Here's a link to a thread that discussed the problem:

http://groups.google.com/group/micr...hread/61a0a92a07c8c414/d483eb205d2d987b?hl=en

Hope this helps.

Pete