In article ,
says...
How can I use solver, or some other excel application to force the sum of a
column to equal a specified number, by allowing the numbers being summed to
either be changed to 0 or remain exactly the same?

It is essentially to determine which 50 or so of 100+ deposits are included
in an enormously large sum (1 large deposit total).

Find a set of amounts that match a target value
http://www.tushar-mehta.com/excel/ti...set-match.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions