I need to figure out out of 10 possible numbers which ones of those 10 equal
a specific number.

An example is:

My total is 50.

I have numbers in cells like this
1, 12, 30, 24, 35, 16, 47, 10, 20

I need to know what this formula of those numbers would be to come up with
the total of 50. The answer would be 30 + 20 = 50

If there a formula that will take that range of number and tell me which
were needed to come up with the total?

Thanks