I have the following table:
FRUIT COLOR TOT Apple red 2 Apple red 14 Apple green 22 Grape black 1 Grape black 4 Grape black 4
I want to dynamically populate a summary sheet like this:
FRUIT COLOR TOT Apple red 16 Apple green 22 Grape black 9
So essentially I need to extract with a dynamic formula distinct categories (fruit) and the relative subcategories (color), so that if I add in the first table a new row with:
Banana yellow 5
It will be automatically added to the summary.
Kinda like this question, but I need it dynamic and with also sub-category.. With only categories I already succeeded in doing it, the real problem are subcategories..