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...
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)
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