Calculation of Categories and Sub Categories with Data Validation.

Hi, I am creating a spreadsheet for reporting of complaints/issues in a hotel and the remedy cost. I plan to use this for tracking trends and for created a display of what the hotel is losing most of its money on.

I have data validation with a category and a subcategory box. The categories range from various hotel categories such as restaurant, check in, incidents etc. The sub category goes into more detail such as food cold, wait time, poor service etc.

I have created all data validations etc but cannot figure out a formula for calculating all the totals. I did do it but my issue is that some sub categories are the same. So different categories but as the subcategory is the same my sumif formula cannot distinguist the difference. I think I may need a sumif formula with multiple conditions but after hours scouring the net I have not been able to find anything suitable.

PLEASE HELP

I have attached a copy of my spreadsheet.

P.S I am a learner.

Will