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).