Hi there,
I need a formula to help me with the following:
the sales figures for 14 month are in a pivot table. I need to calculate the number of people that have bought the product again within 6 months. I have tried count ifs but that is doubling in the instance were you have a value in the second third and forth row, etc.
I also have tried sum product with the same problem. I need to tell excel: If the value in column B is greater than 1, and in either of the columns from C to H there is a value, on the same row, count them in order to established out if the clients that brought the product in Month 2, how many brought again over the following 6 months.
Many thanksTest.xlsx
Bookmarks