Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

FEATURED CONTRIBUTOR

Technical Skill Tuesday: Summing the Largest Values

Viewing on Levo:

Only you can see this list

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!

# # # # #

Make Levo Yours

Levo is the best place to contribute your inspirational thought leadership. Begin elevating the purposeful careers of our community by sharing your insights, data, and stories today.

APPLY TO BE A CONTRIBUTOR