Sum and Sumifs Dynamic Arrays

[mizogy]

Hi All - stumbled upon a problem by which I am trying to identify a solution to whether two dynamic arrays with multiple criteria can be achieved. It works for one of the sum dynamic arrays but when applying two it falls over.

=SUM(SUM(SUMIFS('Ratecard CommercialP&L'!$M$1:$M$500,'Ratecard CommercialP&L'!$I$1:$I$500,"Year 1",'Ratecard CommercialP&L'!$F$1:$F$500,{TN1","TN2"}),'Ratecard CommercialP&L'!$E$1:$E$500,{"Poland T0","Poland T1","Poland T2","Poland TNS","Italy T0","Italy T1","Italy T2","Italy TNS","Spain T0","Spain T1","Spain T2","Spain TNS"}))

Has anyone come across this before?

 

[Fluff]

When using two arrays one needs to be horizontal & the other vertical.
Try

=SUM(SUMIFS('Ratecard CommercialP&L'!$M$1:$M$500,'Ratecard CommercialP&L'!$I$1:$I$500,"Year 1",'Ratecard CommercialP&L'!$F$1:$F$500,{"TN1";"TN2"}),'Ratecard CommercialP&L'!$E$1:$E$500,{"Poland T0","Poland T1","Poland T2","Poland TNS","Italy T0","Italy T1","Italy T2","Italy TNS","Spain T0","Spain T1","Spain T2","Spain TNS"})

 

[mizogy]

When using two arrays one needs to be horizontal & the other vertical.
Try

=SUM(SUMIFS('Ratecard CommercialP&L'!$M$1:$M$500,'Ratecard CommercialP&L'!$I$1:$I$500,"Year 1",'Ratecard CommercialP&L'!$F$1:$F$500,{"TN1";"TN2"}),'Ratecard CommercialP&L'!$E$1:$E$500,{"Poland T0","Poland T1","Poland T2","Poland TNS","Italy T0","Italy T1","Italy T2","Italy TNS","Spain T0","Spain T1","Spain T2","Spain TNS"})

@Fluff - thanks so much and for the prompt reply, that worked a treat! I need to brush up on using two arrays with the need for one to be horizontal and the other vertical

 

[Fluff]

You're welcome & thanks for the feedback.