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.

magnifying-glass

More Career Tips for You


Technical Skill Tuesday: Summing the Largest Values

Skills |

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!

← Previous Article Next Article →

Topics

interview skills2 crushing it the valley

0 Comments

Elizabeth B

A Columbia alumna, Elizabeth Burke is fond of overly long walks and overly long books. Elizabeth is a guitar player and hopeless bluegrass fanatic in her off hours.