Matching customer emails from 2 different sheets to get a count

[LH2022]

Hiya all,

I'm struggling a bit with I have a list of customers who bought Product A (which is a sample of the main product) on one sheet, then I have a list of customers who bought Product B (which is the main product) on another sheet. Is there a way that I can (on a separate summary sheet) show the count of customers who bought Product A and then went on to buy Product B, the only matching information we have is the email address for each customer.

I have done the following formula but I have no idea if its right

=COUNTIFS(Sample_Sales!C:C,"*",Total_Sales!D:D,"*")

 

[etaf]

=SUMPRODUCT(--(COUNTIF(Sample_sales!C2:C100,total_sales!D2:D100)>0))

change the range to match data

Book28
	A	B	C	D
1			2
2
3
Sheet3

Cell Formulas
Range	Formula
C1	C1	=SUMPRODUCT(--(COUNTIF(sample_sales!C1:C100,total_sales!D1:D100)>0))

Book28
	A	B	C	D	E
1
2				email1
3				email4
4
5
6
total_sales

Book28
	A	B	C	D	E
1
2			email1
3			email2
4			email3
5			email4
6			email5
7			email6
8			email7
9			email8
10
11
12
sample_sales

will only be availablefor a few days

count 2 lists-ETAF.xlsx

Shared with Dropbox

www.dropbox.com

 

[LH2022]

=SUMPRODUCT(--(COUNTIF(Sample_sales!C2:C100,total_sales!D2:D100)>0))

change the range to match data

Book28
	A	B	C	D
1			2
2
3
Sheet3

Cell Formulas
Range	Formula
C1	C1	=SUMPRODUCT(--(COUNTIF(sample_sales!C1:C100,total_sales!D1:D100)>0))

Book28
	A	B	C	D	E
1
2				email1
3				email4
4
5
6
total_sales

Book28
	A	B	C	D	E
1
2			email1
3			email2
4			email3
5			email4
6			email5
7			email6
8			email7
9			email8
10
11
12
sample_sales

will only be availablefor a few days

https://www.dropbox.com/s/4g9lebj7qjunk8o/count 2 lists-ETAF.xlsx?dl=0[/URL

Thank you so much! That's worked for me now

 

[etaf]

you are welcome, i will delete the dropbox version