I run the solution function but the result was zero, I believe we suppose to choose the cell y1 where the 'affiliation' text is located...I'm still confused about the function used..Any explanation, please

Hi Asmaa, Can you please share a screenshot with your solution? Thanks!

Hi Asmaa, Great to hear from you. Thanks for the clarification. In this case, the formula that we used was supposed to be applied to the cells in columns X and Y under affiliate. If you use the formula in the solution, it would allow you to fill in EVERGREENSALE20 sales from ads and affiliate and PROMO15 sales from ads and affiliate. Hope this helps! Best, Ned