Forum Discussion
Count.ifs
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...
| 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
Many thanks, but the point is that I need to count how many customers buy product 1 and Product 2, product 1 and product 3,...
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.
- That's right Sergei, unique customers that buy different products, regardless the number of purchases.
Juan
