Is there a way to take a range of numbers and determine which cells and combination of cells (if any) sum to a particular number? For example:

A1=2
A2=4
A3=6
A4=2

I want to know which cells sum to 8. In this case, it would either be A1+A2+A4 or A3+A4. Obviously, this becomes much more difficult when hundreds of numbers are involved.

I’m reconciling two groups of numbers, and I have the total difference between the groups. I suspect that the difference is a combination of 2 or more numbers in one of the groups. The problem is finding those numbers, hence, the mystery formula I need.