View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.