Want to count ID with more sales compared to Target

[AshDil]

Hi,

I have two tables, one with sales and other with target.

Table-1:

ID	SALES
1001	2000
1002	100
1003	500
1010	1000
1005	1500

Table-2:

ID_NO	TARGET
1001	1000
1002	500
1003	1200
1010	800
1005	1000

Now I wanted to count ID having sales morethan target

Eg: For ID = 1001, Sales = 2000 and Target = 1000 we need to count that ID.

Please help me to do it.

Thanks,

AshDil

[CNENFRNL · Accepted solution]

A showcase of powerful Excel worksheet formula,