Try this:

=SUM(A1:A5,-MAX(A1:A5),-MIN(A1:A5))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"DTTODGG" wrote in message
...
Hello-

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

Can you help me?

5.5
4.5
4
3
5.5
=====
drop the 5.5 and 3
add the 4.5 + 3 + 5.5
total = 13

Thank you