see:

http://groups.google.com/group/micro...529de2aaf 685

but generating a table of all the possible combinations and forming the sum
for each combination, the correct combination can be found.
--
Gary's Student
gsnu200701


"Gator" wrote:

is there a way to search a range of numbers that equal a predetermined
amount? say for ex., I have a number in one cell and a set of other numbers.
Is there a way to search the set of numbers to see if there is a combination
of them that add to the singl number?
--
Gator