I have 3 tables from left to right (1), (2), (3), where (1) and (2) are data tables and (3) is the result I would like to have.
Code 101 and 102 in table (2) belong to product group SP. I would like to count how many lines are there where the employee A sold either Product 101 or 102 or both.
How would I do that/ What would be the formula for L3?
Thank you very much!