Sum top 10 unique values

[momoua]

Hi, i'm trying to sum the top 5 entities that distributed in a particular month. However, if an entity distributed more than once in a month then sum the amounts that entity distributed in that month so it is only counted as one entity instead of 2. E.g. if I am doing my report for June 2016, what is the sum of the top 5 entities that distributed in June. Answer = 710. But can i please have an excel formula so i don't have to do this manually each month? Thanks so much!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Entity[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]1/5/16[/TD]
[TD]E-123[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]5/6/16[/TD]
[TD]E-102[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]6/6/16[/TD]
[TD]E-102[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]7/6/16[/TD]
[TD]E-101[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]10/6/16[/TD]
[TD]E-105[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]12/6/16[/TD]
[TD]E-100[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]14/6/16[/TD]
[TD]E-120[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]15/6/16[/TD]
[TD]E-103[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

A PivotTable would make quick work of this task, I think. Do you know how to use PTs?

 

[momoua]

I agree, but is it possible to have a formula outside the pivot table to sum the top 10 values for the month (ensuring that duplicate entities are counted as one)?

 

[momoua]

Actually, pivot table would have the total per entity anyway. ok that would work. thank you