How do I sum a number of columns and ignore the minimum value?

J

Jason Morin

=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
 
G

Gord Dibben

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
 
Top