I want to create a histogram of spenditures and automatically summarize them in a table next to it. So if a value (cell b2) is in the category (b1) "Food" i want the table to automatically add it to its sum.
Food: [Sum of all values in Value column with category value "Food"]
Accomodation: [Sum of all values in Value column w category value "Accomodation"]
What should the formula in the Table summary look like?