Sum the Largest 3 Values
The following formula returns the sum of the largest 3 values in A2:A10...
=SUM(LARGE(A2:A10,{1,2,3}))
Based on the sample data, the formula returns 255.
Sample Workbook: Download
2009 - 2016
2009 - 2016
The following formula returns the sum of the largest 3 values in A2:A10...
=SUM(LARGE(A2:A10,{1,2,3}))
Based on the sample data, the formula returns 255.
Sample Workbook: Download