Formula to Sum values of items selected in a Data Validation List.

Hi all,

I have a worksheet which contains a Summary table and a data table. In the data table, I have some cells which has a drop down menu (created with Data Validation). I would like the summary table to update the sum depending on which item is selected from the drop down list.

Please have a look at the attached file. The summary table has categories which are already listed in the drop down list. If a user selects, say "Fairs" from the drop down list, I want that change to reflect in the summary sheet. ie: Sum of Fairs being updated. If later the item in the list is changed to "Sales Tools" in the drop down list, then the Summary table will update "Sales Tools" instead and re-adjust the "Fairs" total.

In other words, I am looking for a dynamic update in the sum of the items of the Summary Table, depending on any changes made in the items being selected from the drop down list.

Any ideas on how to do this?

LIST_SAMPLE.xlsx

here you go:
LIST_SAMPLE.xlsx

use a sumif, a sumif looks for all values that = the value you're looking for then gives you the corresponding value in the sum

in your cell B3
=SUMIF(B11:B20,A3,C11:C20)

drag it down.
If you have more than the 4 items on the sample for the Data Validation, you can use your summary table as the Data Validation list itself.