Sum values in a range to a result

  • Thread starter Thread starter Bruno
  • Start date Start date
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
 
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
(e-mail address removed)
dguillett
 
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
 
Back
Top