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!

Date	Entity	Amount
1/5/16	E-123	100
5/6/16	E-102	200
6/6/16	E-102	300
7/6/16	E-101	100
10/6/16	E-105	60
12/6/16	E-100	20
14/6/16	E-120	30
15/6/16	E-103	10

<tbody>
</tbody>

 

[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