What formula can I use to sum largest 2 numbers out of data set?

  • Thread starter Thread starter Excel Novice
  • Start date Start date
E

Excel Novice

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
 
Hi
Try this:
=SUM(LARGE(A1:A4,{1,2}))
A1:A4 range needs to be changed to suit your requirements.

HTH
Michael M
 
Back
Top