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.
|