One way

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

Also check out the LARGE and SMALL functions.


On Sun, 6 Mar 2005 15:23:07 -0800, "
osoft.com wrote:

How do I create a formula in Excel 2003 where if I have six colums of
numbers, and I would like to get the sum of these six numbers, excluding the
highest and lowest number? Is this possible?