I want to get (or reach) a particular sum by adding a series of prerecorded numbers in a row.

In detail, it is all about storing data on CD/DVD etc. Suppose I've 20 folders/files of sizes (in MB), 0120 0135 0154 1264 1123 1258 1369 1548 2435 0228 1254 1364 0752 0689 0842 0566 0698 2356 1786 0052 et al.
I want to accomodate optimum no of files in a CD (650/700/735MB) or a DVD (4.38GB) so that the capacity of the medium exploted to its max. I've used sorting data in Excel but that requires manoeuvering. I want the display in this fashion:
Column "A" : File/Folder Size(s) (Requires Input, containing at least 20 rows)
Column "B" : File/Folder Selection(s) (This is the data picked up from column "A")
Column "C" : Combination Size (Sum of the sizes displayed in Column "B", eventually, it would be nearest to the size of destination drive)
Column "D" : Medium/Drive Size (Requires Input)

Can someone help me out?

Thanks in advance.