To be able to Total amount of occurrences in a dropdown list & total costs

[crr4253]

I am looking to produce a expenses sheet which has simply has 50 possible values (which can change) and I need to total the amount of each expense.



I have created a source list of 50 types of expense (text) on spreadsheet (the reason for this is the source list will need to be updated and in turn update the values elsewhere in the sheet)



Using this list as a source, column A has a dropdown box in every row allowing any of these 50 items to be selected. Column B holds monetary values which relate to the expenses in column A. I need to be able to total the monetary values in column B for each of the possible types of expense


Thanks for reading this hope you can help