Suppose I have something like:

A1 = 500
A2 = 650
A3 = 725
A4 = 18
A5 = 1000

A10 = 1518

A10 is the sum of A1+A4+A5. How would I get Excel to tell me what combination of numbers in a particular range equal a known value?