sumifs and filtered data

Hi everyone,

I have an issues here with using a sumifs function. Working great apart from when I need to filter the data in the table its referencing. Does anyone know how to get this to work properly? I've attached a spreadsheet to show what I'm referring to.

"Sheet1" has the sumifs and the data I'm looking to pull. "ALSchedule" contains the data.

So for example. Currently I have a filter applied to "Type" column in "ALSchedule". In "Sheet1", cell b5, the amount that should have been showing at the moment should have been $102,965,001.92. But, the sumifs is picking up the filtered-out categories which you'll be able to see.

If anyone can help me with a workaround that'd be great. Thank you!