how to add 5 numbers dropping the high and low

[Becky]

I need the function that will add 3 cells out of 5 cells
by dropping the highest and the lowest values. For
instance if the five cells contained:
5.5 6.5 6.5 5.5 5.5
I need to drop one 6.5(high) and one 5.5(low) and come up
with a sum of 17.5. Any help appreciated.

Becky

 

[Chip Pearson]

Becky,

Try something like the following:

=SUM(LARGE(A1:E1,{2,3,4}))

Change A1:E1 to the appropriate range.

 

[Harlan Grove]

I need the function that will add 3 cells out of 5 cells
by dropping the highest and the lowest values. For
instance if the five cells contained:
5.5 6.5 6.5 5.5 5.5
I need to drop one 6.5(high) and one 5.5(low) and come up
with a sum of 17.5. Any help appreciated.

=SUM(A1:E1)-MAX(A1:E1)-MIN(A1:E1)