Dec 02 2020 01:11 AM
Good morning,
I have in one column a list of customers and in another column the products that each customer is buying.
I want to count, for each pair of products, the number of customers that buys them.
If tried to do it using +count.ifs, but it does not work.
What am i missing?
I attach the worksheet I´m using.
Thankyou very much
Dec 02 2020 03:14 AM
Hi @Jarama11,
Just to make sure I understand your request:
You want see the number of customers who bought product 15 (F2) plus the number of customers who bought product 28 (G2), if so, the following formula will help
=COUNTIFS($B$2:$B$446,"="&F2)+COUNTIFS($B$2:$B$446,"="&G2)
Dec 02 2020 03:18 AM
That could be
=COUNTA(UNIQUE(FILTER(A2:A446,COUNTIF($B$2:$B$446,$F2)*COUNTIF($B$2:$B$446,$G2))))
Dec 02 2020 03:45 AM
Nos of Product | Product | Total Product Sale | Customer | Total buy |
1 | Product 1 | 32 | Customer 50 | 13 |
2 | Product 10 | 7 | Customer 35 | 16 |
find attached sheet
Total Sale = =COUNTIF(B:B,H2)
Total buy by customer = COUNTIF(A:A,J2)
Total Sale =445
Dec 02 2020 03:54 AM
Dec 02 2020 05:14 AM
Dec 02 2020 06:37 AM
Hi,
No, I do not need to count the number of customers that buy product 15 plus the number of customers that buy product 28, but the number of customers that buy product 15 AND product 28 (the pair).
Thanks
Juan
Dec 02 2020 10:57 AM - edited Dec 02 2020 11:00 AM
Dec 02 2020 12:30 PM
My assumption - number of unique customers. One customer could purchase same pair of products several times, so we need number of customers, not number of purchases.
Dec 02 2020 01:51 PM
Dec 02 2020 10:42 PM