how to add 5 numbers dropping the high and low

  • Thread starter Thread starter Becky
  • Start date Start date
B

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
 
Becky,

Try something like the following:

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

Change A1:E1 to the appropriate range.
 
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.
Click to expand...

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