Finding number of unique value based on another value

Seeking solution of the following problem

1. There are fixed number of member working under Area Manager
2. In "Data" sheet I have to put monthly selling data in same format. Every month end I've to calculate incentive amount for Area Manager
3. Not all members under Area Manager can sell. Few members can sell who comes in "Data" sheet
4. Incentive amount varies with the number of member which is given under "Incentive Rules". Monthly limit may be changed in future, so amount per member may change.

To get max incentive All Members under Area Manager has to sell. Incentive amount will be number of members who sold multiply incentive per member. My challenge is how can I find out unique number of member based on Area Manager.

It would be nice if I get the formula in "F" Column where I put the figure manually (first I filter Area Manager, then I count member)

Thanks

Thank you for your quick response. These are the REAL NUMBERS I provided as an example. If you go to Data Sheet you will find that 2 members (Mohammad Nasir Uddin-20110556 & Anika Anjum-20160826 given in H column) of AM Md. Nadim Sarker-20090401 managed to sell. I derived the numbers manually i.e by auto filtering of AM.

I need this real numbers through formula which will derive from Data Sheet. Hope you understand.

Thanks

Thanks for your try. Actually my data is anomaly free. Team Member is the seller itself. "G" Column is not necessary here. If any one sells then his name comes to Data Sheet, otherwise not. So Team member in H column is the seller.

Thanks

It's okay. Actually I need how many number of team members are available in Data Sheet under each Area Manager. That number I need in AM sheet.

Attachment 706339

F4 cell , Array formula

HTML Code: 

Great!! This is exactly what I wanted

Thank you very much. This is working well.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.