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

On Thu, 9 Feb 2006 11:25:17 -0800, "DTTODGG"
wrote:

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