Wanting to add best 3 out of 4 numbers in Excel?
GE,
=SUM(A1:A4) - MIN(A1:A4)
or
=SUM(A1:A4) - MAX(A1:A4)
depending on what "Best" means (highest or lowest).
And we generally can't read your mind to know exactly what "etc." means.....
HTH,
Bernie
MS Excel MVP
"GE" wrote in message
...
Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the
same
etc.
|