=SUM(A:G,-MIN(A:G))

However, this only removes the min. value once. If the
minimum value appears several times and you want to
ignore all instances of it, then use:

=SUM(A:G,-SUMIF(A:G,MIN(A:G)))

HTH
Jason
Atlanta, GA

-----Original Message-----

.

Nicole

=SUM(A1:M1)- MIN(A1:M1)

If you have ties for MIN, only one will get dropped.

=SUM(IF(A1:M1<MIN(A1:M1),A1:M1)) entered with CRTL + SHIFT + ENTER will SUM

only cells that are greater than MIN(drop all MIN's)


Gord Dibben Excel MVP


On Thu, 9 Dec 2004 16:41:06 -0800, Nicole
wrote: