View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Just another way:

=SUM(SMALL(A1:A4,{1,2,3}))

In article ,
SteveP wrote:

I am trying to sum 4 numbers discarding the largest number. If two or more
number equal the largest number, only want to discard one of them. What
function can I use and how would I set it up.