Sumifs with data validation

[Alba573]

Good evening,

I'm completely lost trying to figure out how I can solve this issue.

I have created a workbook which contains data points for some outlets and also grouped outlets.

I've made 2 drop down validation lists one for individual stores and other for the grouped, now I would like to get the total sum for each category depending the selection from the drop down cell.

I did manage to get the totals for the first drop down when outlet is selected but cannot figure our when I select group and change the group name.

Your help is much appreciated.

Thanks