How to add 4 of 5 highest numbers using a formula

  • Thread starter Thread starter Guest
  • Start date Start date
or

=SUM(LARGE(A1:A5,{1,2,3,4}))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Extract highest number 6
formula to add the highest value 5
Formula Help - Squaring three highest numbers 7
Return Three Highest Categories 3
Find Highest Value for Each Record 2
highest second highest and third highest 6
Showing the top result from a range of cells 6
Excel How to add numbers in same cell? 2

Back
Top