Adding the 4 highest numbers from a set of 6

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

Guest

I wish to select the best 4 scores out of a maximum of 6 and add them
together to produce a ranking based on that criteria, using XL 2003
 
One way

=SUMPRODUCT(LARGE(A1:A6,ROW(INDIRECT("1:4"))))


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

How do I return multiple values from a single number in a list? 1
Highest number + company 2
Ranking Top 5 in score and percentage 1
Rank based on 2 categories 6
Formula Help - Squaring three highest numbers 7
display order of values without sorting 2
How do I add the 9 highest numbers out of 12? 2
Looking up a value next to a designated cell 3

Back
Top