Find numbers whose sum is a number given

[brhum]

Find numbers(A4:A121) whose sum is a number given(A2)

[macropod]

See, for example: http://www.msofficeforums.com/excel-...html#post77209. Do note that the calculation effort expands exponentially as more cells (quadruplets, quintuplets, etc.) are added to the mix.