How do I sum 4 number discarding the largest number.
 

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.

Hi,

Assuming your numbers are in A1, A2, A3 and A4, the following will work:

=sum(A1:A4)-max(A1:A4)

Happy to Help,

Gary Thomson

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

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.

Thanks, that worked perfectly if your in Jacksonville Fl next week your
invited to play in my golf tournament

"Gary T" wrote:

Hi,

Assuming your numbers are in A1, A2, A3 and A4, the following will work:

=sum(A1:A4)-max(A1:A4)

Happy to Help,

Gary Thomson

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