Hi all,
I have this formula that works perfectly.
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,
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.
I have this formula that works perfectly.
Code:
=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,
Code:
=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)))
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.