Creating a dynamic table that filters based on multiple data validation filters

Hi Everyone,

As the title suggests I'm trying to create a dynamic table that filters based on multiple data validation filters.

The data in the table will be looked up from a raw data tab using SUMIFS.

I just want to be able to filter the table results based on three drop down criteria (data validation) but where it gets confusing is when you want each of the 3 filters to show "All".

I don't know how to structure a IF / SUMIFS formula for all the different combinations that the data could be filtered.

File attached with notes.

Thank you!