finding a value form a combination of figures

iksotof
3StarLounger
Posts: 313
Joined: 04 May 2010, 15:18

finding a value form a combination of figures

Post by iksotof »

Hi, is there a way to find which of a list of values in cells that add up to a given figure? ie if I cells 1 to 5 with 10,20,30,40,50 and I need to know of thise five which add up to 70.


thanks Darren.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: finding a value form a combination of figures

Post by HansV »

As you can see in your example, there can be multiple solutions:

10+20+40 = 70
20+50 = 70
30+40 = 70

Do you want to find ALL solutions, or a solution using as few values as possible, or a solution using as many values as possible, or just any solution?
Best wishes,
Hans