Find numbers(A4:A121) whose sum is a number given(A2)
Find numbers(A4:A121) whose sum is a number given(A2)
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.
Cheers
Paul Edstein
[Fmr MS MVP - Word]