Dec 12 2021 10:55 PM
In Excel - how do you sum top five data entries from a larger dataset
Dec 12 2021 11:06 PM
One solution would be with...
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)
Dec 12 2021 11:15 PM
Dec 12 2021 11:17 PM
Dec 12 2021 11:22 PM
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
Dec 13 2021 01:01 AM
Just another approach using the most underrated excel Formula.
=SUM(AGGREGATE(14,1,D2:D22,{1,2,3,4,5}))
Find attachment
Dec 19 2021 07:06 PM
Thanks for all your replies - using LARGE, AGGREGATE and IFSUM/RANK work - my preference is with LARGE on this occasion... @Craig_Marshall