Feeling Dumb: Need help making SumIfs with Offset and Index work with my specific sheets

Hello!

I've read a ton of threads on how to make sumifs with offset and index work to sum only visible cells that meet certain criteria, but for some reason I just can't make it work on my own workbook. I've uploaded a (largely redacted) version here in hopes that someone can help me.

I'm running into issues because the "Scholarships" tab is a filtered list, and I only want to include SOME of the visible items (if they meet specific criteria).

My ultimate goal is to be able to fill in cell E17 on the "Overview" tab, and have it total the balance of scholarships on the scholarship tab that have "Endowment Spend Rate" in the Type column.

(bonus if you can show me how to add multiple criteria or how to sum everything except those with a certain type-- I'll need to do that later and haven't even started figuring that out yet!)

Thank you so much for anyone who can help!!

My apologies-- I hadn't updated that since I created my account forever ago and forgot it even existed. I am using Excel 2016.