Ever need to know what the 80/20 breakout of your sales force is? What group of folks on your team are making the biggest waves? Or what pages on your site are accounting for the biggest percentage of traffic? There’s a very simple way to do this:

Summing the Largest Values on Your List:

=SUM(LARGE(A1:A100,{1,2,3}))

Explanation:

To find the largest values in your data array, use the Excel command LARGE. LARGE works like this:

=LARGE([Location of your data array], [Which values (indicated by the nth term) to add])

To sum all of these terms, surround your LARGE formula with a SUM formula.

=SUM(LARGE(A1:A100,{1,2,3}))

Voila!