Forum Discussion
About pivot table settings
Could you give me some advice on the following matters? Given two tables like this: --Table 1-- Item A Orange Apple Banana --Table 2-- Item B Item C 1 Orange; Apple 4 ...
=SUMPRODUCT((B$15=$A$9:$A$13)*ISNUMBER(SEARCH($A16,$B$9:$B$13)))An alternative without Excel 365 and without a Pivot Table could be SUMPRODUCT.