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...
That could be
=COUNTA(UNIQUE(FILTER(A2:A446,COUNTIF($B$2:$B$446,$F2)*COUNTIF($B$2:$B$446,$G2))))- Thank you Sergei, let me check it, and I will be back to you..
Juan
