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

New Contributor

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

6 Replies

@Craig_Marshall 

One solution would be with...

LARGE function

You will find description and example in the upper Link.

 

Hope I could help you with this information / link.

 

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

 

 

 

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

@Craig_Marshall It could be done like this:

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

Screenshot 2021-12-13 at 08.15.21.png

Hi @Craig_Marshall 

 

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.

 

tauqeeracma_0-1639379804212.png

 

You may refer to the attached sample file.

 

Thanks

Tauqeer

@Craig_Marshall 

Just another approach using the most underrated excel Formula.

 

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

 Find attachment

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