Sumifs with data validation

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

Why not just

Formula:

Please Login or Register  to view this content.

Hi Bob, It does work however when I change D3 to Outlet and select the store (which should have a value) I don't get any values.

Hi Richard,

Would prefer to have a summary page instead of pivot table, you formula works but when I change D3 to Outlet and select the store (which should have a value) I don't get any values.

Thanks for your solution, however where have my outlets list gone? I would like to be able to view either by Outlet or Group, then I select in my second drop down accordingly.

Hi,

I knew its going to be difficult to explain in writing, but I'll try again.

I would like to achieve as follows:
I will first make the selection in D3 if it's either an outlet or a group; if it's an "Outlet" the list in D5 shows the outlets list and select accordingly, and the YTD expenses will bi for the selected outlet. (this I managed to achieve).
My problem is that when I select "Group" in D3 and the list of groups show in D5 the YTD expenses aren't working(this is what I'm trying to achieve) since the column of the Group names is column P.

So I'll be able to select either "Group" or "Outlet" select the desired in D5 and have the YTD expenses updated accordingly.

Sample file has been updated.

Thanks,
Stephen

Thank you and well done, that's what I was trying to achieve.

Thank you all for your support.

Originally Posted by kvsrinivasamurthy

Pl see my previous post #9.
It is working ok.

Thank you and well done, that's what I was trying to achieve.

Thank you all for your support.