Finding a sum
I am trying to find a way to start with a number and get a group of numbers from a list that sum to the number. For example, if I have the # 30, and I have a list {2,5,10,20}, I know that the numbers from the list that sum to 30 are 10 & 20. Is there a function in Excel that will do this for me?
|