I’m not sure if this is a bug or a formula I’m writing wrong, but here is my issue:
In the last table, I would like to summarize the amount of fruits the Person 1 chose during the week, depending on the Basket.
So, in the last table, for Basket A (row 1), I get “4” as expected (2x Apple + 2x Cherry). For Basket C (row 3), I get “3” as expected (2x Apple + 1x Peer). But, for Basket B (row 2), I get only “1” instead of 2 as I would expect.
It seems my formula doesn’t like the fact that Banana and Melon are in the same cell in Table 2. Here is my formula:
Thanks a lot for your help and have a nice day.