Either

=SUM(A1:A10)-SUM(LARGE(A1:A10,{1,2}))-SUM(SMALL(A1:A10,{1,2}))

or

=SUM(LARGE(A1:A10,ROW(INDIRECT("A3:A"&COUNTA(A1:A1 0)-2))))

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"CHRIS K" wrote in message
...
how do I do a SUM or similar but ignore the two highest and two lowest
values?
there are 36 values in a column.
Thanks
--
CHRISK