Pulling the largest numbers

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

Guest

I have a series of data with the information in rows. For each row - I want
to find the 4 largest numbers, and add them together in the last cell of the
row. I am looking for the best functions to use.

Any help would be greatly appreciated
 
=SUM(LARGE(A1:T1,{1,2,3,4}))
Adjust the range to suit.......

Vaya con Dios,
Chuck, CABGx3
 

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

Back
Top