Find terms that sum to chosen total among a column of numbers?

[lstutchman]

Can you highlight a column of numbers and tell excel to find those numbers in
the column that sum to a number that you choose? And if there are no numbers
in the column that sum to that given total, it will indicate such?

 

[Gary''s Student]

see:

http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[Bernd P]

Hello,

We had a similar question some time ago:
http://groups.google.de/group/micro...required+total+&qt_g=Diese+Gruppe+durchsuchen

Regards,
Bernd