Adding Dynamic Criteria to SUMIFS from Drop-Down Box

Hello, I would greatly appreciate it if i can get help on an issue i spent a lot of time on.
I am trying to update a SUMIFS formula. I have a database that is not a table range. It is a hyperion retrieve that refreshes. In this database i have several names, for example "FY_Budget", etc...

In the sumifs formula, when i enter the name "FY Budget" in the sum range, the formula works perfectly fine.
The problem is I want to replace the name in the sum range and link it to a cell (drop down list with names i created). It is not working.
Can someone please help? My other criteria's don't need to be dynamic, but the sum range should be. Thank You!