How do I sum 4 number discarding the largest number.

S

SteveP

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

Gary T

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
 
S

SteveP

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