"Weekend user" wrote...
Ok, A few weeks ago I asked for help in finding the smallest two numbers
in a group of numbers that were added together in order to reduce the
total by the smallest numbers. the form that was suggested was(using my
cell locations):
=sum(I9,L9,R9,V9,Y9-small((I9,L9,R9,V9,Y9),{1,2}))
....

The reason this doesn't work is because you're subtracting an array from the
single cell Y9, which effectively double-counts Y9 in the sum. With I9=0,
L9=11, R9=9, V9=9 and Y9=15, your sum becomes

SUM(0,11,9,9,15-{0,9}) = SUM(0,11,9,9,{15,6}) = SUM(0,11,9,9,15,6) = 50

Try

=SUM((I9,L9,R9,V9,Y9),-SMALL((I9,L9,R9,V9,Y9),{1,2}))