Matching customer name to list of SKUs they bought

[Grisego]

Hello,

I need help with finding the appropriate formula:

I have:

1. A list of customers
2. A list of promotional SKUs
3. A sales report with the SKU and the name of the customer that purchased it.

Customer Data.xlsx
	G	H	I	J	K	L	M	N	O	P
2	Customer		SKUs				SKU	Quantity	Revenue	Customer
3	John Smith		w1234				w1234	1	5	John Smith
4	Alex Scott		r1567				r1567	5	25	John Smith
5	Carlos Lopez		t5789				t5789	2	10	James Doe
6	Tim Welch		w1234				w1234	3	15	Tim Welch
7	James Doe		r1567				r1567	1	5	Carlos Lopez
8			t5789				t5789	2	10	Carlos Lopez
9			t5790				t5790	10	50	Alex Scott
10			t5791				t5791	12	60	Alex Scott
11			w1234
12			w1235
13			w1236
14			w1237
15			w1238
16			w1239
17
Consolidated

Cell Formulas
Range	Formula
O3:O10	O3	=N3*5

I need to mark, in the list of customers, the number of those SKUs that each customer purchased if they did.

Does anyone have an idea of what I might use?

 

[Fluff]

How about

+Fluff 1.xlsm
	G	H	I	J	K	L	M	N	O	P
1
2	Customer		SKUs				SKU	Quantity	Revenue	Customer
3	John Smith	2	w1234				w1234	1	5	John Smith
4	Alex Scott	2	r1567				r1567	5	25	John Smith
5	Carlos Lopez	2	t5789				t5789	2	10	James Doe
6	Tim Welch	1	w1234				w1234	3	15	Tim Welch
7	James Doe	1	r1567				r1567	1	5	Carlos Lopez
8			t5789				t5789	2	10	Carlos Lopez
9			t5790				t5790	10	50	Alex Scott
10			t5791				t5791	12	60	Alex Scott
11			w1234
12			w1235
13			w1236
14			w1237
15			w1238
16			w1239
17
Main

Cell Formulas
Range	Formula
H3:H7	H3	=ROWS(UNIQUE(FILTER($M$3:$M$10,$P$3:$P$10=G3)))
O3:O10	O3	=N3*5