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
|