Another way:

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

Biff

"William" wrote in message
...
Hi

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

--


XL2003
Regards

William



"Weekend user" wrote in message
...
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}))
This is not working correctly, assume that the the values in the
designated
cells are the following values:0, 11, 9, 9, 15; the value that is
computed
is
50. The only thing that seems to be consistent is that the last value is
added in again then the two smallest values are subtracted. I tried on
several sets of values and it was always coming up the same way, if I add
the
last value in then subtract the two lowest values it matches what Excel
computes. Obviously I am doing something wrong but what?

All comments, and suggestions are welcome and appreciated.