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

[Craig_Marshall]

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

[#2]

@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)

[#3]

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

[#4]

@Craig_Marshall It could be done like this:

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

[#5]

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.

You may refer to the attached sample file.

Thanks

Tauqeer

[#6]

@Craig_Marshall 

Just another approach using the most underrated excel Formula.

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

 Find attachment

[#7]

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