count non repeated items with 2 criteria

[jibu08]

hello everyone, URGENT HELP
need your help in finding a formula..
i have a very large database where i have more than 1000 product and 500 customer .. i need to know what products are listed/sold by each customer .. i have used count-if and count-ifs but it is giving me repeated product ... for eg: luna has 20 product so i need to know 111 customer is selling how many luna product?

Customer code	Product code	Brand	Product
111	10010040 <tbody> </tbody>	Luna <tbody> </tbody>	Luna Green Peas <tbody> </tbody>
111 <tbody> </tbody>	10010050 <tbody> </tbody>	Luna <tbody> </tbody>	Luna Chick Peas <tbody> </tbody>
112 <tbody> </tbody>	10011049 <tbody> </tbody>	ABC <tbody> </tbody>	Dairyland Danish Cheddar Block Coloured <tbody> </tbody>
112 <tbody> </tbody>	10011051 <tbody> </tbody>	ABC	Dairyland Danish Cheddar Block White <tbody> </tbody>
112 <tbody> </tbody>	10036240 <tbody> </tbody>	XXX	Sunbulah Lamb Kebabs <tbody> </tbody>
112 <tbody> </tbody>	10010050 <tbody> </tbody>	Luna	Luna Chick Peas 400 Gm <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[oldbrewer]

custcode	prodcode
1	a
2	d
3	f
4	m
5	p
1	b				Count of prodcode	prodcode
2	e				custcode	a	b	c	d	e	f	g	h	j	k	m	n	o	p	q	Grand Total
3	g				1	2	2	2													6
4	n				2				3	3											6
5	q				3						1	1	1	1	2						6
1	c				4											2	2	2			6
2	d				5														3	3	6
3	h				Grand Total	2	2	2	3	3	1	1	1	1	2	2	2	2	3	3	30
4	o
5	p
1	a
2	e
3	j
4	m				a pivot table will list each unique prodcode for each custcode
5	q
1	b
2	d
3	k
4	n
5	p
1	c
2	e
3	k
4	o
5	q

<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1060995-excel-questions.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).