Retrieving an array with INDEX

[Norty]

Hi all,

I have this formula that works perfectly.

=SUM(COUNTIFS(Table5[Type],"inbound",Table5[Disposition],"Abandoned in queue",Table5[Month],C6,Table5[Service/Campaign],{"Sweden";"Denmark"}))

Now I would like to move the {"Sweden";"Denmark"} part to an cell so that I can use this formula for multiple countries. Something like this,

=SUM(COUNTIFS(Table5[Type],"inbound",Table5[Disposition],"Abandoned in queue",Table5[Month],C6,Table5[Service/Campaign],INDEX($V$5:$W$10,MATCH($D$3,$V$5:$V$10,0),2)))

And in W5 I have {"Sweden";"Denmark"}.

This doesn't work as Excel puts " around the brackets to mark them as text.

Is there a way for me to return an array in my formula? Not a value from an array, but the whole array as an array.

 

[Norty]

Just after I wrote this post I found this solution.
https://excelxor.com/2014/09/05/index-returning-an-array-of-values/

Works for me, so I leave it here if anyone else has the same problem in the future.