Hi RD,

No of course you are correct, there is nothing to coerce so no need.

habit I guess :-(.

Bob


"RagDyer" wrote in message
...
Bob,
Is there really a need for the unary in your formulas?<g
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"Bob Phillips" wrote in message
...
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