Adding Multiple Columns using multiple criteria

Hi

I need some help on a formula in cell E17 of the Summary Tab of the attached spreadsheet which will sum all the amounts for the 6 months for ‘Short Term Care’ for the ‘Metro’ area for the year FY 2023 by looking up all the values and descriptions in the ‘Output-Detailed Costs. Similarly for FY 2024.

For example in the attached spreadsheet in cell E17 of the summary tab I have a simple formula for which adds all the staff development costs for FY 2023 for Short Term Care in the Metro region.

Is there any way one can do a formula which doesn’t require so much manual calculations?