Assuming 1st number in A1, =SUM(A1:E1)-(MIN(A1:E1)+MAX(A1:E1)) ought to
do it.

mjlevie wrote:
I have a group of numbers
5 2 3 5 9
4 3 5 9 7
1 1 1 9 9

I want to total the columns. However I don't want the max and the min in
each row to be used. And I only want the left most min or max excluded. For
example on the last row I only want the first 1 and the first 9 excluded.
Thanks for any help you can give me.