SUMIFS with multiple criteria but only with one constant ARRAY?

Dear all,

The problem:
I have a sum(sumifs(..) formula going on in which one of the criteria is based on the outcome of a dropdown box. The dropdownbox is some kind of slicer in the data.
Now I also wanted to add the option to have all data and not have to chose something from the box. So i make a ARRAY constant with all options, in this way, the formula sums everything up when I chose ALL from drop down.
Eg:

Dropdown box:
Type 1
Type 2
Type 3
ALL TYPES

I use this formula:

=SUM(SUMIFS(Data!AA:AA,....multiple other constraints....,Data!AK:AK,IF($F$1="ALL TYPES",Allegrootte,$F$1)))

F1 is the cell that shows the outcome of my dropdown box on the dashboard page. Column AK on tab DATA inlcudes the type mapping of my data. So when I choose ALL TYPES, the condition will become the array "Allegrootte" which is defined as ={"Type 1","Type 2","Type 3"}.

So far so good, this thing works perfectly and I can get different charts/data when I pick a type from the dropdown and i can also still get the data for all types summed up.

Now I want to add anotther dropdown box to slice the data, say geography.

Region A
Region B
Region C
ALL REGIONS


Following the same logic I do this:

=SUM(SUMIFS(Data!AA:AA,....multiple other constraints....,Data!AK:AK,IF($F$1="ALL TYPES",Allegrootte,$F$1),Data!AL:AL,IF($F$1="ALL REGIONS",Alletypes,$F$1)))

Where Alletypes is defined as ={"Region A","Region B","Region C"}

Now the formula stops working and I get 0 as result for all my data.

Is this a limitation of excel or is there something else playing? (ps. I am using the Ctrl+Shift+ENTER)

Thank you in advance for you help and time.

Kind regards
Thijs

Thank you XOR, it's logic when you see the explanation

I might need to use the sumproduct in the future, so thanks for the tip.

KR,
Thijs