View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default What formula can I use to sum largest 2 numbers out of data set?

Hi
Try this:
=SUM(LARGE(A1:A4,{1,2}))
A1:A4 range needs to be changed to suit your requirements.

HTH
Michael M

"Excel Novice" wrote:

I'm creating a spreadsheet to add up scores but only want the highest 2
values out of 4 to be added together? What formuls could I use to do this?

Thanks