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
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