Hi Ben,

Try this

=SUM(D1:D10)-SUMPRODUCT(--(LARGE(D1:D10,{1;2}))+(SMALL(D1:D10,{1;2})))

or if there will be 10 then you could use

=SUMPRODUCT(--(LARGE(D1:D10,ROW(INDIRECT("3:8")))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Big Ben" wrote in
message ...

Hello,

I have a list of ten values. I would like to sum this list with the
top 2 and bottom 2 values removed in the sum calculation.

Any help would be great,

ben


--
Big Ben
------------------------------------------------------------------------
Big Ben's Profile:
http://www.excelforum.com/member.php...fo&userid=6431
View this thread: http://www.excelforum.com/showthread...hreadid=395038