I have 100s of cells containing various numeric amounts. There is a specified amount I need to find, which will be the sum of any number of values - could be 2 values, could be 12.
For example I have the following data:
10
20
30
40
50
60
70
80
90
100
Let's say my target value is 150. Obviously there are several ways I could add these numbers to get 150. I need a formula that will combine various values to get my target number.
For the life of me, I can't figure out how to do this.
Thoughts?
For example I have the following data:
10
20
30
40
50
60
70
80
90
100
Let's say my target value is 150. Obviously there are several ways I could add these numbers to get 150. I need a formula that will combine various values to get my target number.
For the life of me, I can't figure out how to do this.
Thoughts?