New Contributor

# In Excel - how do you sum top five data entries from a larger dataset

In Excel - how do you sum top five data entries from a larger dataset

6 Replies

# Re: In Excel - how do you sum top five data entries from a larger dataset

One solution would be with...

LARGE function

You will find description and example in the upper Link.

NikolinoDE
I know that I don't know anything (Socrates)

# Re: In Excel - how do you sum top five data entries from a larger dataset

I can see how that would work - bit cumbersome though - where are all the Excel Functions located?

# Re: In Excel - how do you sum top five data entries from a larger dataset

@Craig_Marshall It could be done like this:

``=SUM(LARGE(D1:D25,{1,2,3,4,5}))``

# Re: In Excel - how do you sum top five data entries from a larger dataset

You may also achieve your requirements with a helper column in which all values will be ranked using the RANK() function and then use the SUMIFS() function.

You may refer to the attached sample file.

Thanks

Tauqeer

# Re: In Excel - how do you sum top five data entries from a larger dataset

Just another approach using the most underrated excel Formula.

``=SUM(AGGREGATE(14,1,D2:D22,{1,2,3,4,5}))``

Find attachment

# Re: In Excel - how do you sum top five data entries from a larger dataset

Thanks for all your replies - using LARGE, AGGREGATE and IFSUM/RANK work - my preference is with LARGE on this occasion... @Craig_Marshall