How do I sum 4 number discarding the largest number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks, that worked perfectly if your in Jacksonville Fl next week your
invited to play in my golf tournament
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
How to multiply arrays and get the largest number in the resultingarray ? 11
picking largest number 4
Sum largest numbers based on condition 6
How to use large function? 5
Finding the largest match 9
large combine max fuction issue 1
How to look up a value? 9

Back
Top