is there a way to set up a group of numbers and then of that group of
numbers get excel to figure which ones will give a total sum when asked?
such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know
which numbers in that group would add up to 56 (10,17,9,20). Any help here?

not sure how posts are done here.. I will be looking or an answer could be
emailed to
thanks

checkout:

http://www.tushar-mehta.com/excel/te.../match_values/
--
Gary''s Student - gsnu200858


"Flya172" wrote:

is there a way to set up a group of numbers and then of that group of
numbers get excel to figure which ones will give a total sum when asked?
such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know
which numbers in that group would add up to 56 (10,17,9,20). Any help here?

not sure how posts are done here.. I will be looking or an answer could be
emailed to
thanks