Drop 2 high and 2 low - help!

[DTTODGG]

Hello-

I need to take 7 numbers (each in separate cells) (they could be the same),
drop the 2 highest and 2 lowest and then add the remaining 3.

Can you help me?
4
3.5
5.5
4.5
4
3
5.5
=====


Thank you

 

[Ron Rosenfeld]

Hello-

I need to take 7 numbers (each in separate cells) (they could be the same),
drop the 2 highest and 2 lowest and then add the remaining 3.

Can you help me?
4
3.5
5.5
4.5
4
3
5.5
=====


Thank you

To do exactly what you describe, with your numbers in A1:A7, try:

=SUM(LARGE(A1:A7,{3,4,5}))

A more general solution:

=SUM(LARGE(rng,ROW(INDIRECT("3:"&COUNT(rng)-2))))

array-entered with <ctrl><shift><enter>


--ron