Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sum a number of columns and ignore the minimum value?
|
#2
|
|||
|
|||
=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----- . |
#3
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|