Sum values in a range to a result

B

Bruno

Hi,

i have a range, and i want to know which combination of cells of this
range give me a specific value. These combinations should be obtained
summing cells of that range.

Thanks
 
D

Don Guillett Excel MVP

Hi,

i have a range, and i want to know which combination of cells of this
range give me a specific value. These combinations should be obtained
summing cells of that range.

Thanks
Click to expand...

Post your samples with expected results or send your file to me at
[email protected]
dguillett
 
M

Matt Richardson

Hi,

i have a range, and i want to know which combination of cells of this
range give me a specific value. These combinations should be obtained
summing cells of that range.

Thanks
Click to expand...

Try this link:-
http://www.tushar-mehta.com/excel/templates/match_values/index.html

It gives two examples of how you can do this, one using solver and the
other using VBA. I personally prefer the VBA method as it returns all
possibilities, whereas Solver only gives the first it finds (and is
somewhat temperamental).

HTH
Matt
http://2toria.com
http://teachr.blogspot.com
 
Top